New
#11
I am having this exact same issue. I'm curious if anyone has solved it?
This is happening to me very randomly and not with files that are from an email attachment. It is happening most if I try to save more than once - either when saving portions of the sheet as pdf files or saving the excel file as a new name. The first time it will save, any other times it will not. This seems to be happening most often, if not exclusively, with .xlsx files. Again, the occurances are random, and aren't completely true to any particular trend.
My office programs were just installed yesterday, so they're up to date. I've tried everything I can think of and am at a loss.
I came across this when I started using 2010. Files as attachments must first be saved to your HDD. Once saved there, open excel and try a file save then.
There appears to be 2 problems described in these posts
1) hitting Save or Save As and nothing happens
2) problems saving a document that has already been saved
#1 has happened to me when you open a document that somehow is in the 'protected' mode.
I have not found out how to turn that 'feature' off but if you do a copy all and pase into a new workbook it will save
#2 seems to happen when somehow Excel seems to lose the location of the file or you get the error message; "An unexpected error has occurred. AutoRecover has been disabled for the session." Then after a couple of clicks Excel asks if you want to overwrite the file and then freezes (timing circle goes on for ever). when you close Excel and it finds the file again it was to the last save version and not the latest version.
Any of the fixes from Microsoft do not seem to work, turning off Add-on's does not work and
FWIW, I resolved that problem on my Asus Eee PC running Windows 7 Pro and Office 2010 by uninstalling PowerPivot for Excel, then rebooting. Now, no Excel save or save-as issues, whether saving to HDD or USB. I can't guarantee it'll work for you, but if you're not using PowerPivot, it's worth a try.
To uninstall, go to Control Panel/Programs and Services and find the listing for PowerPivot for Excel in the grouping for Microsoft SQL Server. Click on it and click on 'uninstall' at the top of the frame.
--Quire
Last edited by Quire; 14 Jul 2011 at 08:08. Reason: added emphasis
Thanks Quire, this has resolved my issue for several users!
Will now look at re-installing the PowerPivot add-in however this has resolved the issue for now