Office 2010 not saving changes on 2003 xls
Hi, I'm having a very annoying problem with a mixed windows 7 xp environment. The computers have also some office 2003 PC's and some using Office 2010.
I have seen users edit an excel spreadsheet written in 2003 on a 2010 version of Excel but only to find that any changes they made are not reflected on the document when opened on another computer! They have to go back to the PC they were on to open the document and see the changes?! If they save the file as the new excel 2010 format then they are able to view the changes on both computers (as long as the computer has the compatiablility pack installed.)
I have checked and double checked the folder they are saving to and they are saving in the same location!!! It doesn't complain when saving in office 2010 either, it saves it but only to find the changes do not reflect on the spreadsheet when opened up in office 2003.
This is such a strange problem that I'm struggling to figure out why it's happening.
I really don't want to have to go backwards and install 2003 office on any of the new coputers..
Anybody any ideas?