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

 

How to change the upload size restriction (can I upload a 10mb doc/xls or a 1GB doc/xls) within Central Admin so that display a workbook in a web part (browser) using Excel Services.

1. Log in to Central Admin as a Farm Administrator
2. Click “Application Management” in the left nav.
3. Click “Manage service applications” under Service Applications.
4. Click “Excel Services Application” next to “Excel Services Application Web Service Application”  Note: not the item in grey under this (Proxy). You want the blue item.
5. 
6. Click the “Trusted File Locations” link:
7. 
8. Then, select the reports library or document library your web part is calling or where the files are.
9. Scroll down to “Workbook Properties” and change the ‘Maximum Workbook Size” if it’s set to 10mb’s try and change it to 50 or 100mb’s and save the change. Note: 20mb is the default configuration.
10. 
11. Go back to the page with the reports web part and refresh it.

    This should fix your issue with “This workbook is larger than the maximum workbook size allowed to be opened in the browser” and Excel Services in SharePoint 2010.

    Here’s a link to help you out: TechNet – http://technet.microsoft.com/en-us/library/ff191192.aspx