by joe.pesch
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.
-
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.
7d7609bc-ba85-4bda-84c0-df73ab323f16|1|4.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04
Tags:
Sharepoint