Link to home
Start Free TrialLog in
Avatar of Mayogroup
Mayogroup

asked on

Can open Excel file on Sharepoint 2010. Workbook is larger than the maximum workbook size allowed to be opened in the browser.

One of our users has uploaded several excel files to our Sharepoint 2010 site.

When users try to open these files, they receive the error msg:


"Workbook is larger than the maximum workbook size allowed to be opened in the browser".

 as with all Excel docs in Sharepoint 2010, they try open within the browser by default.
All the files are just over 10MB.

What is the limit for opening Excel files via the browser in Sharepoint 2010?
Is there a way to increase the limit? If so, will this cause problems?
Avatar of Mayogroup
Mayogroup

ASKER

Also just to add, I know the workaround is just to tell the users to manually open by selecting "Edit in Microsoft Excel", but would prefer not to have this as the permenant solution.
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That sucks!!
Is there any possibility to set so if under 2MB - open with Browser, and if over 2MB - open with Excel?
Or is there a way to increase the limit?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial