While working with SharePoint 2013, checking the audit log
reports in excel got the error as shown below. I have already configured the
excel service as shown in the msdn.
Start -> run -> enter “%WINDIR%\Temp folder.
Click on properties, select security tab, click on Edit button
Add Modify permissions to WSS_WPG group and do IISRESET.
Checked the event logs, shows the error below.
Unable to access the workbook cache “C:\Windows\TEMP\Excel
Server\FileCache\d8746073-d542-5f43-9b0d-45d345fd9f43\Workbooks. Excel Services
Application unable to function without a workbook cache.
After some
troubleshoot found that the root problem is that to create or access the
workbook. This is a permission issue. As a managed account, the Excel Services
application pool is a member of WSS_WPG security group, to execute the
permissions on the Temp folder.
To fix the issue I have followed the steps below,
Start -> run -> enter “%WINDIR%\Temp folder.
Click on properties, select security tab, click on Edit button
Add Modify permissions to WSS_WPG group and do IISRESET.
Now everything will work as expected.
Here we can grant permissions to each and every application
pool. Here I just granted the permissions to the WSS_WPG group in other managed
accounts need to create temporary cache files.
