MS Excel (2013) Opening Files from 97-2003 Not Enough Memory/Space Issue

RTM2007
RTM2007 used Ask the Experts™
on
Received this error when opening .XLS files in Excel 2013:

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

We were able to get around it by opening the file properties and UNBLOCK'ing the file but would like to turn this feature off for good, as this does not set permanently for files opened that are not saved in a file location (i.e. Excel files attached to an e-mail).
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
jayneeIT Manager

Commented:
Presumably there actually *is* plenty of disk space!  Please check this technet link RTM2007 and see if it applies (opening excel files via IIS):
http://social.technet.microsoft.com/forums/en-US/officesetupdeployprevious/thread/2c753037-4600-4a4f-abd7-d228e2f20a38/
jayneeIT Manager

Commented:
Also try this regsitry fix:
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/microsoft-excel-cannot-open-or-save-any-more/ab1a73d9-1666-4cf5-a6a7-285d2004dd08

Suggestion is to:
1.run regedt32

2.check/change the value of

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders->Cache

ie check validity of folder used here (local to user, plenty of space, correct permissions).
Commented:
Hi RTM2007 can you also have a look in Excel at
File > Options > Trust Center > Trust Center Settings… > Protected View
uncheck all those boxes, restart Excel and try again?
..Terry

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial