Microsoft Excel cannot open or save any more documents

Issue

A scheduled task does not produce a report and the following message appears in the log file for that task:

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.

Resolution

The resolution of this issue depends upon the version and edition of Windows you are using:

1. For ALL versions of Windows , the folder “C:\Windows\System32\config\systemprofile\desktop” must exist and you need Full Control permissions to the “systemprofile” and “desktop” directories.

2. For 64-bit versions of Windows 7 or Server 2008 and higher, the “C:\Windows\SysWOW64\config\systemprofile\desktop” folder must also exist and you need Full Control permissions to the systemprofile and desktop directories.

3. For 64-bit versions of Windows Vista , the “C:\Windows\SysWOW\config\systemprofile\desktop” folder must also exist and you need Full Control permissions to the systemprofile ” and desktop directories.

4. For Windows 8.1/Server 2012 and higher , in addition to the above, the Windows Registry Key.

   [ HKEY_Current_User\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\Cache ]

   must be set to C:\Windows\Temp