Excel workbook disk cache full (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010 Enterprise

Alert Name:   Excel Workbook disk cache is full

Event ID:   No event ID

Summary: Excel Services Application saves workbooks it loads to a temporary cache on disk. The hard disk on the Excel Services Application server computer is full and Excel Services Application cannot save additional workbooks to that cache.

Symptoms: Intermittent workbook load failure.

  • The following event may appear in event log: Event ID: 2015 Description: Failed to load <workbook URL> with error: 'The workbook cache is full, or does not contain enough free space to load the workbook. (workbook cache size is <size in MB> MB)'. [Session: <session ID> User: <username>].

  • The following event may appear in event log: Event ID: 2016 Description: Failed to load '<workbook URL> with error: 'The disk containing the workbook cache is full, or does not contain enough space to load the workbook’. [Session: <session ID> User: <username>].

Cause:

  • The hard disk on the server for Excel Services Application is full.

  • The hard disk is not full, but the workbook cache size is set to too low a value.

Ensure there is enough disk space on the server

  • Ensure there is enough disk space on the server.

  • If disk space is running low, delete unused files or add disk space to the server.

Increase the Maximum Size of Workbook Cache setting

  • On Central Administration home page, click Application Management.

  • On the Application Management page, under Service Applications, click Manage service applications.

  • Click the Excel Services Application. By default this has the name “Excel Service Application”.

  • On the Manage Excel Services Application page, click Global Settings.

  • On the Excel Services Application Settings page, under Workbook Cache, type the number of megabytes (MB) of disk space that you want Excel Services Application to use for the workbook cache files in the Maximum Size of Workbook Cache box.

  • Click OK.