Monday, June 2, 2014

Unable to create or access workbook cache

 

All of a sudden people started getting these errors while opening Excel files in the browser:

at C:\Windows\TEMP\Excel Server\FileCache\fa812204-b6ff-40ec-9209-fe8add3de89e\Ranges. Excel Services Application is unable to function without a workbook cache.

Thanks to below links, issue could be resolved

http://sensoft2000-sharepoint.blogspot.ae/2010/10/error-unable-to-create-or-access.html

http://technet.microsoft.com/en-us/library/ee513091(v=office.14).aspx

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)

clip_image002

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.

1 comment:

  1. Thank You! For once Google delivered the answer I needed and did not have to read through two hours of non-sensical Google results.

    ReplyDelete