For some strange reasons if you are getting “Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space” error while opening Excel 2019 or 2016/2016 or Office 365 documents from local disk or Outlook attachment, here is the working solution fix it. 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 an irrelevant error message.
How to Fix Microsoft Excel Cannot Open or Save…..Not Enough Available Memory or Disk Space Issue in Excel 2013/2016/2019/Office 365
As said earlier, this is something to do with the built-in security settings of Excel 2019 or 2016/365. Follow these simple steps to troubleshoot the issue.
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 the error, that should open without any problems now. This method used to help me to fix the problem at my workplace especially when the user tries to open the Excell attachment from Outlook.
Hope this small guide is useful in fixing this minor but still important issue with Excel 2019/2016 on Windows Operating systems.