The excel workbook shows error on my clients intranet homepage which is a excel web access webpart. Which checking the backend file and opening it with excel services has same error but when opened in excel it open fine.
Error: ” An Error has occurred. Please try again.
Investigations: The previous night there has been a power outage to the data center and next morning this is not working.
When the same file is renamed and saved again it works fine with excel web app so it could be something related to cache on the sever.
Then the eventlog on one of the frontend shows this error in application
Error: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache
Bang on !!! when verified the “ranges” folder is missing on one of the WFE and the same excel url is tested on other WFE’s which also displays error. I suppose the cache for each excel file using excel service is stored only on one server irrespective of which WFE this file is served.
Restore the folders in the path of the cache resolved the issue:
This path has the following folders “Images”, “Ranges”, “SavedWorkbooks”, “Workbooks”
In case if that is also not working for you, you could remove the whole directory “Excel Server” in windows\temp folder and make sure the excel service application pool account has access to recreated folder at that path and restart the IIS should create the folder back again and rebuilt the cache as necessary.
More Detailed description and resoulution at: http://technet.microsoft.com/en-us/library/ee513091(v=office.14).aspx