Joseph Michael Pesch
VP Programming

Excel Services in SharePoint 2010 Error: This workbook is larger than the maximum workbook size allowed to be opened in the browser

by 24. October 2012 08:10

By default the maximum file size that can be opened in the browser (by Excel services) is 10MB.  This is managed through the Central Administration > Application Management > Manage Service Applications > Excel Services > Trusted File Locations.  Below is an excerpt from Microsofts documentation on this topic located here: http://technet.microsoft.com/en-us/library/ff191194.aspx  When you attempt to open a file larger than this setting allows you will receive this error message: "This workbook is larger than the maximum workbook size allowed to be opened in the browser"

In the Workbook Properties section, you determine the resource capacity for the server when Excel Services opens workbooks.

Performance and resource availability can be compromised if users open extensive workbooks. If you do not manage the approved size that workbooks running in open Excel Calculation Services sessions can have, you risk having users exceed your resource capacity and overloading the server.

  1. In the Maximum Workbook Size box, type a value in megabytes (MB) for the maximum size of workbooks that Excel Calculation Services can open. The default size is 10 megabytes. 

Tags:

Sharepoint

Comments are closed