Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space.

Anonymous

Hello,

I am running Office Pro Plus 2013.

I try to open a 35KB xlsx and I get this message:

"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."

I have 200GB free on drive C and 16GB RAM with only 18% in use according to task manager. My Users folder is actually on D: (it's a hard shorctut) and this has 800GB free.

Excel is opening all other things fine and all other office apps work fine (as does everything else) it's just this one small xlsx that is causing me problems.

Googling comes up with lots of results and all seem to either boil down to user error (insufficient disk space) or an incorrect path. A egistry hack, which I've tried, sets the Cache folder to point to c:\Windows\Temp. This makes no difference (but everything else still works)

The spreadsheet in question has been downloaded from Google docs. I've tried a few times to download and always get the same. I've also tried the ods format and I get the same results in Excel. Downloading as PDF, or CSV is fine.

Any ideas?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi,

Thank you for posting in Microsoft Community. As I understand, you are unable to open a particular Excel file which is downloaded from the Google docs.

Since the issue occurs with a particular file, it might be file specific issue.

Just a quick question:

What is the format of the File?

Save the file locally on the system and then try to open the file and check if it opens fine.

Right click on the saved file, click on Properties and uncheck the option Block and then try to open the file and check.

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.

I hope the above suggestions helps to resolve your issue. If you need any further assistance reply and we will be glad to assist you.

Thank you.

0 comments

183 additional answers

Anonymous

2016-02-11T18:03:55+00:00

This may work well for Windows, but there is no "options>trust center>settings path in the Mac version. How do I get rid of this stupid thing on the Mac?
Was this answer helpful?

0 comments No comments
Anonymous

2016-02-11T14:13:19+00:00

Very helpful answer.
Was this answer helpful?

0 comments No comments
Anonymous

2016-01-16T19:11:57+00:00

Yeah well that update did not make itself visible yet.

I have always used Office and I have an Office encrypted excel sheet with some passwords for local availabilty. It has 5 sheets, each with a list of passwords and documents/locations. No scripts or anything. The Excel was originally made in office 97 and has survived all version up to 2013, and then you invent this **** about protected locations and what not that have been posted in this thread.

Let me tell you that I store the sheet on a redundant network storage with TERABYTES of space, I use MAPPED DRIVES with NO extra quirks, directly from the Windows OS with YOUR interface. I sit on a W10 machine with a recent OS upgrade and an 8Core CPU with 32GB of internal memory and 100's of GIGABYTES available on the local C drive.

I could not open the file from the network share

I could not open the file locally

There was no BLOCK option in the file properties

I finally opened the file after virtually going NUTS in the Trusted Center and DISABLED EVERYFUCKINGTHING related to security for Macros, VBA scripts, file locations (I added c:\*.* as location) and not until AFTER that I was able to open the file.

You gave me a severe scare, cost me hours of troubleshooting, and almost caused me to loose access to several placers and resources which I have paid a lot to have.

IDIOTS!!!
Was this answer helpful?

0 comments No comments
Anonymous

2016-01-15T23:46:19+00:00

Hi everyone!

We have an updated driver now available via Windows Update to help with this issue.

In Windows 10, select the Start button > Settings >Update & security > Windows Update.

If you happened to disable hardware acceleration as a workaround before the driver was available, you should re-enable it to avoid potential performance issues. More info here on how to do that.

Have a great weekend.
Was this answer helpful?

0 comments No comments