Unable to create or access workbook cache. Excel Services Application is unable to function without a workbook cache Event ID 5226

Unable to create or access workbook cache

Tags: Unable to create or access workbook cache, sharepoint 2013 unable to create or access workbook cache, sharepoint 2010 unable to create or access workbook cache, sharepoint 2016 unable to create or access workbook cache, Excel Services Application is unable to function without a workbook cache Event ID 5226, excel services application is unable to function without a workbook cache

In this post, we will discuss how to resolve an error which says: Unable to create or access workbook cache at c:\Windows\Temp\Excel Server\FileCache\<GUID>\Ranges. Excel Services Application is unable to function without a workbook cache.

The error looks like below:

Unable to create or access workbook cache
Unable to create or access workbook cache

Cause:
The account that runs the application pool in which Excel Services Application runs might not have permissions to create a directory on the Excel Services Application server computer.



Solutions:
To fix this issue,
1. Go to your server and navigate parent folder %windir%temp folder

2. Right-click over temp folder select properties and select security Tab over properties dialog box

3. Find WSS_WPG(server\WSS_WPG) by Scroll down group and usernames

sharepoint 2016 Unable to create or access workbook cache
sharepoint 2016 Unable to create or access workbook cache

4. Click on edit and select WSS_WPG(server\WSS_WPG)and give full permission which has read and execute permissions on the Temp folder

sharepoint 2013 Unable to create or access workbook cache
sharepoint 2013 Unable to create or access workbook cache

Read some SharePoint tutorials:

5. Give ok and close that, now the problem will get fixed.


You May Also like the Following SharePoint Online Tutorials: