Excel Services Event ID: 5226

If you have installed SharePoint per default configurations you will most likely not get issues like this, but in most enterprise installs logs and temp files are relocated. To fix the error below. Please review error then read below for solution.

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Calculation Services
Event ID: 5226
Date: 10/15/2008
Time: 9:32:36 AM
User: N/A
Computer: CR2RCHIISIME
Description:
Unable to create or access workbook cache at D:\Temp\Excel Server\FileCache\BaselII-CIT-SSP-423345403\Charts. Excel Services is unable to function without a workbook cache.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Solution I manually created the D:\Temp\Excel Server\FileCache\BaselII-CIT-SSP-423345403\Charts directory then on the Security tab for the Temp directory, the WSS_ADMIN_WPG Windows group should have Full Control and the WSS_WPG Windows group should have Read & Execute, List Folder Contents, and Read permissions or higher on the folder. If they do not, assign these permissions by using the procedure in the "Assign sufficient permissions" section.

Also, this solution works if you get Trace Log errors.