Hey Everybody,



I've been having a problem when I try to save something twice... I'll try to explain it best I can, bear in mind I'm not the best with computers .


I'll open an existing, or brand new, spreadsheet and make some changes. Then I click the save, or ctrl+s, and the document saves just fine. I then have to save the file to another location, so I do save as, which also goes smoothly. Now, if I happen to make more changes and try to save those changes, nothing happens. When I click save, it doesn't save. When I click save as, a dialog box doesn't even appear.
However, when I go to close out of Excel it'll still ask me if I want to save the changes. At which point it doesn't matter if I click save, or don't save, because the changes will not be saved no matter what.

Does anybody have any ideas here?


I'm running 2010 Excel 32b on XP if that helps.

Hi,

I'm not sure, to be honest. Does the problem only occur when you save it to a specific place, or does it happen if you save it anywhere else?

__________________
Colin

RAD Excel Blog

It happens after I use the 'Save as...' Once I 'Save as...' once, I can't save it to anywhere else. If I use the normal save, I can save it just fine. But once I switch to the save as... so I can save it to another location, it doesn't seem to like that very much apparently.

When you SaveAs for the first time, a window pops up for you to choose the location. At the bottom of the window there is a Save As Type dropdown list. What File type is showing in there?

__________________
Colin

RAD Excel Blog

It's a .xlsx file

There's a long article of problems/fixes around saving Excel files here:
http://support.microsoft.com/kb/271513

I scanned through it but none of the symptoms on there seem to precisely match yours. Worth a look though in case something stands out at you.

When you do the first saveas to another location, is that other location a local drive, a network drive, etc..? Does it make any difference if you vary it, or does the problem repeat wholesale no matter where you saved the file?

__________________
Colin

RAD Excel Blog

I've played around with it and it happens whenever I do a save as. Whether I save to the network, my documents, etc.

I'll take a look through that link you posted and hopefully I can figure something out. Usually I remember to close out and re-open Excel after I do a save as, so it doesn't matter too much. But sometimes I'll forget and have to redo everything I just did and it's a pain in the rear if I had done a lot...

I'd definitely try opening Excel in safe mode (disable all add-ins). It shouldn't be behaving like that - I can imagine what an annoyance it must be for you.

__________________
Colin

RAD Excel Blog