Excel Services – Large Workbook Error


You may receive one of the following errors when attempting to view an Excel workbook in SharePoint depending on your version of SharePoint:

 

 

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

 

 

“Couldn’t Open the Workbook. Wow, That’s a big workbook. Unfortunately, we can’t open a workbook larger than 10 MB. You’ll need to open this in Excel.”

 

The reason for these errors is the size of the workbook that is being opened is larger that the maximum size of a workbook that can be opened in Excel Services. The maximum size can be configured in the Excel Services settings.

In order to change this value, open SharePoint Central Administration, and go to Application Management > Manage Service Applications > ExcelServiceApp > Trusted File Locations and click on the appropriate Address. Under the Workbook Properties section you will see a Maximum Workbook Size option. Set this value to the required file size in MB, and click OK to save the setting. To avoid the errors above, make sure the value is higher than the largest workbook size in SharePoint.

 

Another error you may see in SharePoint with large workbooks is the following:

 

“Sorry, something went wrong. The form submission cannot be processed because it exceeded the maximum length allowed by the Web administrator. Please resubmit the form with less data.”

 

You may encounter the error when you try to publish a large workbook to SharePoint that exceeds SharePoint’s Maximum Upload Size. You can increase this value by going to the following setting in SharePoint Central Administration:

 

Application Management > Web Applications > Manage web applications > (Choose Web Application) > General Settings > Maximum Upload Size

 

 

 

Increase the value to a value larger than the size of the workbook causing the error. After saving the value, you should be able to upload the file successfully.

 

Additional Articles:

Error “Request timed out” when you try to upload a large file to a document library on a Windows SharePoint Services 3.0 site
http://support.microsoft.com/kb/925083

Configure Maximum File Upload Size (PowerPivot for SharePoint)
http://technet.microsoft.com/en-us/library/ff487972.aspx

Issues Uploading Large Files To SharePoint
http://blogs.technet.com/b/praveenh/archive/2012/11/16/issues-with-uploading-large-documents-on-document-library-wss-3-0-amp-moss-2007.aspx

Comments (5)

  1. Anonymous says:

    any way to do this in Office365?

  2. Anonymous says:

    Helped me a lot ! Thanks !

  3. Fabian says:

    Hello to all, if you don’t have the Office web app server implemented there is another way to do it, this also should be a valid solution for Office 365. "In order to change this value, open SharePoint Central Administration, and go to Application Management
    > Manage Service Applications > ExcelServiceApp > Trusted File Locations and click on the appropriate Address. Under the Workbook Properties section you will see a Maximum Workbook Size option. Set this value to the required file size in MB, and click OK to
    save the setting. To avoid the errors above, make sure the value is higher than the largest workbook size in SharePoint.". Link to the original post:

    http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/08/13/excel-services-large-workbook-error.aspx

  4. Fabian says:

    hahaha, I’ve made the comment on the wrong thread, thanks for your tips because they helped me solve my problem. Kind regards!.

  5. Emanuele says:

    Hi all an thanks for this old post.
    In order to get the limit overridden, I had to set to 50MB in EVERY site of my farm and set also to 10 the Maximum Chart or Image Size.
    +1 beer!