Home → Troubleshooting → All Products: Other Issues → "Microsoft Excel cannot open or save any more documents ..."
Applies to:
Excel 2016, with @RISK open
When I have @RISK open, and try to open a file using File » Open in Excel's menu, I get this error:
Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.
· To make more memory available, close workbooks or programs you no longer need.
· To free disk space, delete files you no longer need from the disk you are saving to.
The same thing happens if I double-click an Excel file in Windows' File Explorer while @RISK is open in Excel.
The actual problem has nothing to do with disk space. Excel is trying to display a security warning about the file you want to open, but for some reason it is unable to. Security warnings typically come for files you downloaded from the Internet, but not always. To work around this problem, you need to answer the security prompt before Microsoft Excel tries to display it. There are two methods to do this:
Method 1 (by file): Before trying to open the file in Excel, find it in Windows' File Explorer. Right-click the file and select Properties. At the bottom of the General tab, click the Unblock button. Once you unblock a file, Windows should remember and Excel should not ask you again.
This option is available for some file types, but not others. If you don't have an Unblock button, use Method 2.
Method 2 (by folder): This option is better if you usually store your downloaded Excel files in one folder. In Excel, click File » Options » Trust Center » Trust Center Settings » Trusted Locations. Click Add new location. Browse to the folder where you store your Excel files, select Subfolders of this location are also trusted, and click OK.
Last edited: 2019-06-27