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.