If you were ever greeted by a message similar to the following:
"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."
By default Excel Web App is set to a max size of 10 MB, here are my findings for other Office Web Apps 2013 documents:
The workbook size is controlled by a property ExcelWorkbookSizeMax, to get the current value of this property
Log onto the Office Web Apps 2013 Server > Open PowerShell and type
To change this value from 10 MB to lest say 50 MB, just execute the following in PowerShell
Set-OfficeWebAppsFarm -ExcelWorkbookSizeMax 50
And there you have it, happy SharePointing :)
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: