Problem: Whenever client wanted to
open the attached Excel file from a SharePoint List or library. He gets the below error.
In Central Administration, in Application Management, click Manage service applications.
Applies to: SharePoint Server 2010
Error
message: This workbook is larger than the
maximum workbook size allowed to be opened in the browser.
Reason:
By default the Maximum workbook upload size allowed in SharePoint is 10mb (this
was 100mb in 2007 environment) increase this to 50 MB the issue goes away.
How
to do this:
In Central Administration, in Application Management, click Manage service applications.
Click Excel Services Application.
Click Trusted File Locations.
Click the location. This will be an added trusted file
location for the site collection or a new file location.
Scroll to Workbook Properties.
In Maximum Workbook Size, increase the file size from 10 to
50
Reference
Article: http://technet.microsoft.com/en-in/library/ff487972.aspx Applies to: SharePoint Server 2010
SharePoint Foundation 2013.
No comments:
Post a Comment