See all How-To Articles

How to Fix When Excel Cannot Open or Save Any More Documents

This tutorial will discuss some ways to fix the “cannot open or save any more documents” error in Excel.

 

save error example

 

If your file came from a different computer and you were either sent it via email or downloaded it from the internet, it might be blocked due to its security settings.

Check File Security

If your file came from a different computer and you were either sent it via email or downloaded it from the internet, it might be blocked due to it’s security settings.

  1. Close your Excel file then navigate to the file in the Windows Explorer.
  2. Right-click on the file and click on Properties.

 

save error unblock file

 

  1. Select the General tab and then make sure the check box next to Unblock is checked.
    If you do not see this checkbox, the file did not come from another computer, and this property will not be available.
  2. Click OK to apply the setting.

Amend Excel Security Settings

Check that Protected View is not enabled as this too can sometimes cause this error.

  1. In the Ribbon, select File > Options and then select Trust Center.
  2. Click on Trust Center Settings.

 

save error trust center settings

 

  1. Select Protected View and make sure that all the checkboxes are unchecked in the Protected View area.

 

save error trust center

 

    1. Click OK.
    2. Restart Excel for the settings to take effect.