Home > SharePoint 2010, SharePoint Problems/Issues > SharePoint 2010: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\Workbooks

SharePoint 2010: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\Workbooks

I ran into an issue recently with Excel Services when trying to open up Excel files on the portal where the Opening Documents in the Browser option was set to open in the browser.   When trying to opening up the excel file in the browser I would get the error message:  “An error has occurred.  Please try again” and the browser window will close out not allowing me to view the file.  Looking on the SharePoint web front end servers I was noticing this error in the event viewer:

Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\<GUID>\Workbooks

When I browsed to that location on the server I did not see a directory structure for Excel Server\FileCache\<GUID>\Workbooks.  Somehow this directory was deleted or was never created when the Excel Services was configured.

By default the Excel Services Application saves the workbooks it loads to a temporary cache on disk. In this case, a workbook disk cache cannot be created on the Excel Services Application server computer due to permissions, disk I/O Errors, or space.

If you run into this issue, these are the steps I took to fix the problem.

1.  Log into all Web Front End Servers that report the above errors in the event viewer.
2.  Browse to C:\WINDOWS\TEMP and create the directory structure for the Excel Server found in the event viewer error manually.
3.  Go back to Central Administration, and stop/restart the Excel Calculation Services on all the web front end servers.

Central Administration|System Settings|Manage Services on server|Excel Calculation Services

4.  Repeat these steps for any others errors like this you might find.

Browse back to the location on the portal, this should fix the issue with opening up the Excel Files in the browser.

 

Advertisements
  1. January 20, 2016 at 6:14 am

    Thank you!
    Restart the Excel Calculation Services is not necessary. You just need create folder at step 2.

  2. evtrifonov
    January 20, 2016 at 6:15 am

    Thank you!
    Restart the Excel Calculation Services in not necessary, you just need create the folder at step 2.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: