For some strange reasons if you get “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space” error while opening Excel 2013 or 2016 document from local disk or Outlook attachment, here is the working solution. This will work on most of the Windows Operating Systems including Windows 10, 8.1 or Windows 7 since this is related to Excel problem/settings.
Unfortunately the error message will not make any sense. Your PC will have enough disk space in C or D drive and memory while opening these Excel files. Do not go by the error message. Mostly these Excel files will have some kind or complicated formulas, calculations, or external resources inside the Excel sheets, therefore the security settings in Excel will prevent opening these files and throw irrelevant error message.
How to Fix Microsoft Excel Cannot Open or Save…..Not Enough Available Memory or Disk Space Issue in Excel 2013/2016
As said earlier, this is something to do with the built-in security settings of Excel 2013 or 2016.
1) Create a new Excel file, then go to Options from File Menu.
2) Open Trust Center Settings as shown below.
3) Under the Trust Center settings, uncheck the all checkboxes in Protected View as below.
This setting will allow the Excel file to open without any security errors or warnings like “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space”. Once you pressed OK and applied the settings, now open the same Excel file which used to give error, that should work fine.
Hope this small guide would be useful in fixing this minor but still important issue with Excel 2013/2016 on Windows Operating systems.