Microsoft Excel is an app that most of us prefer using when handling data and when we need to save important data for important tasks or for future use. However, just like any other app or program, even the Excel comes with its own set of problems.
Many times, you may receive an excel sheet via email from someone or you downloaded a spreadsheet from some website, and when you try to open the Excel sheet, bang comes an error message, “Microsoft Excel cannot open or save any more documents because there is not enough memory“.
Apparently, the issue is not related to your system memory at all. It’s mostly a security warning related to the specific file, that prevents you to open the Excel file for some reason. These warnings can be specifically for the files downloaded from the web, but may not be the same for all files.
So, how do we fix this issue? Let’s see how.
Method 1: Through Properties
Step 1: Go to your desktop and right-click on the Excel file (that’s giving the error while opening), and select Properties from the right-click menu.
Step 2: In the Properties window, under the General tab, go straight towards the bottom, up to the Security section. Check the box next to Unblock.
Press Apply and then OK to save the changes and exit.
And, that’s it. You can now try opening the Excel file and it should open without any error. However, if this does not work, try the 2nd method.
Method 2: Via File Explorer
Step 1: Press the Windows + E keys together on your keyboard to open the File Explorer. Click on This PC shortcut on the left side of the window, and on the right side, click to open the C drive.
Step 2: Now, follow the path as shown below to reach the Temp folder:
- Go to Users
- Go to your UserName
- Click to open AppData
- Go to Local
- Click to open the Temp folder
Step 3: Now, press the Ctrl + A keys together on your keyboard to select all the temporary files in the folder, and hit Delete.
*Note – If you don’t see the AppData folder, then go to the View tab at the top of the folder. Click on the Show/hide option, and check the box next to Hidden items.
This will make any hidden files and folders visible.
That’s all. Now, try to open the Excel file and it should open smoothly without any errors.