- #Excel not enough memory to open file how to#
- #Excel not enough memory to open file drivers#
- #Excel not enough memory to open file windows 10#
Hope this small guide is useful in fixing this minor but still important issue with Excel 2019/2016 on Windows Operating systems. What do you think? is Windows Defender good enough as main Anti-virus solution? 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. 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 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”.
#Excel not enough memory to open file windows 10#
Please close other applications and try again.' I had a Windows 10 Pro 64bit (version 1909) and Microsoft Office Professional Plus 2013 (32bit). Follow these simple steps to troubleshoot the issue.ġ) Create a new Excel file, then go to Options from File Menu.Ģ) Open Trust Center Settings as shown below.ģ) Under the Trust Center settings, uncheck the all checkboxes in Protected View as below. Using the file explorer to preview excel files, and got 'Not enough memory to run Microsoft Excel.
#Excel not enough memory to open file how to#
How to Fix Microsoft Excel Cannot Open or Save….Not Enough Available Memory or Disk Space Issue in Excel 2013/2016/2019/Office 365Īs said earlier, this is something to do with the built-in security settings of Excel 2019 or 2016/365. If you are still unable to open the file in Excel then open the file in CSV format, save the file as Excel file (.xlsx) and then try to open the file and check.
Read Also: How to enable or disable track changes in MS Word 2016 Right click on the file, click on Properties and uncheck the option Block and then try to open the file and check. 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. Your PC will have enough disk space in C or D drive and memory while opening these Excel files. If your computer is still coming up with Not Enough Memory Error, run SFC Scan Command to.
#Excel not enough memory to open file drivers#
Windows will scan your computer for Hardware changes and update device drivers (if required). On the Device Manager Screen, click on Action > Scan for hardware changes. Unfortunately, the error message will not make any sense. Right-click on the Start button and click on Device Manager. > A colleague of mine, having half as much memory than I do, can open. 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. message 'Not enough memory.' > Im using win2000 SP3 and Excel 97 SR-2, my PC has got 1GB RAM. 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.
0 kommentar(er)
