Wednesday, August 20, 2014

SharePoint trouble shooting - error to load excel in webpart page

The ULS log shows the error as below,

Unable to create or access workbook cache at C:\Windows\TEMP\Excel Server\FileCache\46deae92-790c-4b89-86e3-3719a2edcf01\Ranges. Excel Services Application is unable to function without a workbook cache.

CachedFile.SaveFile: Threw exception: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Windows\TEMP\Excel Server\FileCache\46deae92-790c-4b89-86e3-3719a2edcf01\Ranges\5dfc1857-7543-4418-9cf1-37102e27d6fb.xlsrvrng'.
1. Run Power shell command $app = Get-SPExcelServiceApplication , $app.ApplicationPool to check if the service account has the permission to the folder
 
C:\Windows\TEMP\Excel Server

2. Just delete the excel service application folders in the cache and refresh, then it worked.

No comments: