Excel 2010 not saving.

[Derrickp]

Hi I have had office 2010 installed for about 2 months now but on a regular basis when I am working in Excel I am unable to save the document. When I select save or saveas nothing happens and when I close the document I am asked if I want to save and again if I select yes nothing happens. Currently my only workaround is to email the document to myself.

How can I go about reporting this to Microsoft or find a patch for this bug?

Regards,
DP

 

[Dinesh]

Have you installed the latest updates for Office 2010?

 

[Derrickp]

I am not sure where to find them. I have looked before. Any pointers?

Regards,
DP

 

[Dinesh]

Yes there is. Go to Windows Updates and click Change Settings.

Select Microsoft Updates. Then check for updates.

 

[Bill2]

Kb980232 seems to have caused some of these issues. Try uninstalling it. It also appears theres a fix, you can try installing that.

You cannot save documents to a folder or change the permission settings of folders on a SMB 1.0-based remote server from a Windows-based computer that has security update 980232 (MS10-020) installed

 

[Derrickp]

Thanks for your help Dinesh. I have checked and my system is up to date but the problem still exists.

 

[Dinesh]

Try reinstalling Office 2010. It must fix this issue.

 

[Derrickp]

Thanks Dinesh I'll give it a go.

 

[Derrickp]

Hi Dinesh,

I have uninstalled office and reinstalled twice and the problem still exists. It would appear to be more prevalent when the excel document originates from an email attachment. It is almost as if the document is flagged as read only. The system will not let me save or save as.

How do I log this as an issue with Microsoft?

Derrick

 

[Lomai]

Hi

Have you had a look at this - microsoft link?

Notes before you start to troubleshoot the issue

If you are currently experiencing this problem with a file that you have not yet saved successfully, see the Save your Excel file before you start to troubleshoot the issue section before you continue to troubleshoot this problem.

If you want to know more about how Excel saves files, see the Process for saving an Excel file section.

To troubleshoot an Excel save issue, follow these steps in the order that they appear until the problem is resolved.

Step 1: Try to save the Excel file to another location

If you can save the Excel file correctly when you save it to a local hard disk drive, to a network drive, or to a floppy drive, the following are possible causes for the issues that you are experiencing:

• Antivirus software conflict
• Restricted permissions
• Network connection lost
• File name length
• File sharing conflict

If you cannot save the Excel file correctly when you save it to a local hard disk drive, to a network drive, or to a floppy drive, the following are possible causes for the issues that you are experiencing:

• Transition Formula Evaluation feature
• Template contains an embedded object

If neither of these are the cause, try step 2.

Step 2: Try to save a new Excel file to the original location

To save a new Excel file to the original location, follow these steps:

1. Create a new Excel workbook.
2. On the File menu, click Save As.
3. In the Save As dialog box, follow these steps:
   1. In the Save in box, click the location where your original Excel file is saved.
   2. In the File name box, type a new name for your new Excel file.
   3. Click Save.

If you can save a new Excel file to the original location, the following are possible causes:

• File name length
• File sharing conflict

If you cannot save a new Excel file to the original location, the following is a possible cause:

• Insufficient drive space

If you have sufficient drive space, try step 3.

Step 3: Try to save the Excel file in Microsoft Windows Safe Mode

If step 1 and step 2 has not resolved the issue, restart Windows in Safe Mode, and then try to save your Excel file to your local hard-disk drive.

Note If you use a network location to save your Excel files, try to restart Windows in Safe Mode with network support, and then try to save your Excel file.

For more information about how to start Windows in Safe Mode or about how to perform a clean boot, click the following article numbers to view the articles in the Microsoft Knowledge Base: 156126 (http://support.microsoft.com/kb/156126/ ) Troubleshooting Windows 95 using Safe Mode
192926 (http://support.microsoft.com/kb/192926/ ) How to perform clean-boot troubleshooting for Windows 98
267288 (http://support.microsoft.com/kb/267288/ ) How to perform a clean boot in Windows Millennium Edition
266169 (http://support.microsoft.com/kb/266169/ ) How to troubleshoot problems with Standby mode, Hibernate mode, and shutting down your computer in Windows 2000
281770 (http://support.microsoft.com/kb/281770/ ) How to perform clean-boot troubleshooting for Windows 2000

If the Excel file saves after you restart Windows in Safe Mode, try to resave the file again. To do so, click Save on the File menu.

If the Excel file does not save (or save again) after you restart Windows in Safe Mode, the following are possible causes:

• Third-party add-in
• Terminate and Stay Ready (TSR) program
• Antivirus software conflict
• Restricted permissions
• File name length

 

[Lomai]

Hi Dinesh,

I have uninstalled office and reinstalled twice and the problem still exists. It would appear to be more prevalent when the excel document originates from an email attachment. It is almost as if the document is flagged as read only. The system will not let me save or save as.

How do I log this as an issue with Microsoft?

Derrick

What anti-virus software are you running?

 

[bcdavis75]

I am having this exact same issue. I'm curious if anyone has solved it?

 

[Golden]

Hi Dinesh,

I have uninstalled office and reinstalled twice and the problem still exists. It would appear to be more prevalent when the excel document originates from an email attachment. It is almost as if the document is flagged as read only. The system will not let me save or save as.
Derrick

Derrick - can you check to see if the attachment is saved as Read-Only? As you say, this would prevent you from making changes and saving.

 

[JuliaReynolds]

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.

 

[meebers]

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.

 

[bduerr]

Excel save problems

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

 

[Quire]

Resolution for the Excel 2010 not-saving problem

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

 

[patch1334]

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