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!?