Tuesday, October 12, 2010

Error: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache

Error: 
Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache.

(you can see this error in Event viewer)

Reason:
Unknowingly you may have deleted the above mentioned folders. So, Excel services is not able to save the temporary files under the "Ranges" folder.

Solution:
Login inside the SharePoint server and create the "Ranges" folder as per the above mentioned folder structure. If you are not able to see the "Excel Server" folder inside "C:\Windows\Temp" folder, just create it manually.

If you see any other error like this, create the missing folder.

Thats it... 

3 comments:

  1. Cool man, u rock :) saved my time like anything, keep it coming .

    ReplyDelete
  2. Recreating the folders helps until they get deleted again. Do you have any idea why the folders are deleted automatically?

    ReplyDelete
  3. Hello. Had the same problem, but my folders was not deleted but corrupt. I don't know how that happened but i renamed them and recreated the images and Ranges folders, now working again.

    ReplyDelete