Tuesday, March 4, 2014

This workbook is larger than the maximum workbook size allowed to be opened in the browser

This is the error message that is displayed when a user tries to view an Excel workbook in the browser that is larger than the maximum size allowed in Excel Services.

To update Excel Services, do the following:

  1. Log into Central Administration
  2. Under the Application Management heading, click Manage service applications
  3. Click the link that says Excel Services Application (the blue text)
  4. Click Trusted File Locations
  5. Hover over the Trusted File Location name and use the drop down to select Edit
  6. Scroll down until you reach Workbook Properties and update the value for Maximum Workbook Size.