Advice through experience in Office 365, Security, and Azure
Microsoft Excel Memory or Disk Space Opening Error – The Solution

Microsoft Excel Memory or Disk Space Opening Error – The Solution

Have you ever tried to open a Microsoft Excel document received in Outlook and encountered the error message below?

“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.”

Screen Capture:

Excel 
Microsoft excel cannot open or more document' because there i:' not enough available merr" or 05k 
• to more memory close workbooks or you no longer need. 
• ro tree disk space. delete no longer need from the disk you are 'hing to.

When you receive this error like I have, you probably tried a few of these fixes below but were left without a solution:

  • You most likely opened Task Manager to view your current system resources only to find plenty of memory available, plenty of CPU available, and plenty of disk space available. And when I say plenty, I mean at least 60% of these resources are available.
  • You may have done a Repair under the Windows 10/Settings/Apps area on the Office 365 installation. The repair may take 15 minutes or longer for the system to complete. However, this does not correct the issue.
  • The actions above are normal research and corrective actions to take, but in this case we are no closer to a solution.

I have encountered into this issue a few times and  finally figured out a solution. To start, the error message does not align to the actual issue. The issue is really a security related prompt with a relatively easy fix. I say relatively easy fix because as the instructions below will indicate, it is a security related check box that needs disabled. However, you must understand the implications of this action.

Below are steps to correct this issue followed by a section about understanding the security related concerns of following them.

Solution Steps:

The solution is to uncheck a security setting from within Microsoft Excel that is enabled by default to protect your system from malicious files received through Outlook.

Note: Remember to re-enable this setting once you have successfully opened your file.

  1. In Microsoft Excel, click on File
Home 
X cut 
Paste 
Insert 
Format Painter 
Clipboard

2. In the left index area of Excel, at the bottom of the screen is an option called Options. Click on it.

Open 
Gö 工 。

3. In the Excel Options screen that appears, click Trust Options on the lower left of the screen.

Excel Options 
General 
Formulas 
Proofing 
Language 
Ease of Access 
Advanced 
Customize Ribbon 
Quick Access Toolbar 
Add-ins 
Trust Center 
Experiment 
Help keep your documents safe and your computer secure and healthy. 
Security & more 
Visit Office.com to learn more about protecting your privacy and security. 
Microsoft Trust Center 
Microsoft Excel T rust Center 
The Trust Center contains security and privacy settings. These settings help keep your 
computer secure. We recommend that you do not change these settings. 
Irust Center Settings...

4. Then click Trust Center Settings…

Microsoft Excel T rust Center 
The Trust Center contains security and privacy settings. These settings help keep your 
computer secure. We recommend that you do not change these settings. 
Irust Center Settings...

5. In the Trust Center settings, click Protected View on the left.

Trust Center 
Trusted Publishers 
Trusted Locations 
Trusted Documents 
Trusted Add-in Catalogs 
Add- ins 
ActiveX Settings 
Macro Settings 
Protected View 
Message Bar 
External Content 
File Block Settings 
Privacy Options 
Form- based Sign- in 
P rotected View 
Protected View opens potentially dangerous files, without any security prompts, in a restricted mode to help 
minimize harm to your computer. By disabling Protected View you could be exposing your computer to possible 
security threats. 
Enable Protected View for files originating from the Internet 
Enable Protected View for files located in potentially unsafe locations 
Enable Protected View for Outlook attachments@ 
Security settings for opening Text-Based files (.csv, .dif and sylk) from an untrusted source 
C) Always open untrusted lext-8ased files (.csv, .dif and .sylk) in protected view 
Security settings for opening Database files (.dbf) from an untrusted source 
C) Always open untrusted Qatabase files (.dbf) in protected view

6. By default, all three areas are selected. To correct the issue, de-select the option “Enable Protected View for Outlook Attachments.”

P rotected View 
Protected View opens potentially dangerous files, without any security prompts, in a restricted mode to help 
minimize harm to your computer. By disabling Protected View you could be exposing your computer to possible 
security threats. 
Enable Protected View for files originating from the Internet 
Enable Protected View for files located in potentially unsafe locations 
Enable Protected View for Outlook attachments@

7. Select OK several times to save the settings.

8. Attempt to open the document again and you will now be prompted to verify you want to open this document and that you trust the sender. The document should now open correctly.

9. Important: Once your file is opened, make sure you then re-enable this setting as it is key to help protect your system!

Understanding Important Security Concerns

It is important to understand that this setting is in place by default to protect you as the user from opening a file that may be malicious. Even if you know who the sender of the file is, there is no way to tell if that person’s email or system has been infected. Prior to opening this file please consider taking the following steps to protect yourself.

  • Verify you have the latest Microsoft Windows updates installed by going to Settings and Windows Update.
  • Verify you have an active antivirus agent on your system. Windows 10 now comes with Microsoft Defender at no cost and is rated “the best antivirus tool for Windows 10 PCs.”  Make sure it is enabled by opening the Microsoft Security Center on your laptop or desktop.
  • Submit the file for viruses and malicious activity, prior to opening it. First, save the file to your desktop. Secondly, submit it to one of these reputable services to be scanned. If this is a document with sensitive information, I do not recommend submitting this file to any website for scanning. In this case, seek professional technical assistance.

9 Comments

  1. As usual microsoft has an error message that has nothing to do with the actual bug. In my case, it was “potentially unsafe locations” that needed to be unchecked. Perhaps you can uncheck each one one-by-one or just uncheck all 3 options to see quickly if this is the problem.

    File opened without problems. Thanks so much for a useful guide.

    Jon
  2. I had similar error when creating new excel document.

    After correcting key in registry, error was gone.

    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders
    I’ve set Cache to :
    C:\Windows\Temp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: