Question: I am trying to open an Excel file but keep getting 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”. How do I fix this error? I am using Excel 2013.
How to Fix Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space
This error in Excel is commonly caused by Excel’s blocking feature. Excel blocks certain files for security reasons to prevent the user from unwanted viruses. Here are the steps to fixing this error:
- Using Windows Explorer, navigate to the folder which contains the Excel file.
- Right click on the file and click on Properties.
- Uncheck the Block option.
- Click OK.
Open the file again and it should open without any error. This is the solution which will work 99.9% of the time.
If the Excel file giving the error message is hosted on an external server like Google Drive or Dropbox, you can save the file on your local hard drive to perform the above action.
For really stubborn Excel files, you can open the file in CSV format and then save it back as a .xlsx format. Here are the steps to follow: Open a blank workbook. Go to Data Tab from the Ribbon. Click on From Text from Get External Data section. Select your file and complete the Text Import Wizard.