Ok… I've searched a lot for this, but it's not an easy question to search for!
When I open any files (xls, or xlsx) in Excel 2007, excel acts like it's a read only file, essentially creating a new file with the name plus a 1 on the end…
Eg. I open NewDoc.xlsx Excel opens it as NewDoc1.xlsx and the save button brings up the save as dialogue in my default folder.
Does anyone know how to set it back to allowing me to open, edit and save a document without having to browse to the original document and save over it!?
My immediate thought was access permissions, but the file is in a network folder with my user given Full Control, I also tried creating a new file in that folder, and also on my local machine just in case – same result. To make it even stranger, if I browse to the original file using the save as dialogue, it will let me save over the original, without any further prompts.
Best Answer
I seem to have resolved this by running the Repair portion of the Office 2k7 setup installation option
(For future reference, this is accessed via Add/Remove programs in the control panel and clicking 'Change' for MS Office 2007, and then selecting Repair)
Chris