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

Mayogroup
Mayogroup used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
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.
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

the maximum size for Excel files to be viewed with Office Web apps is 2MB. It's not much, I agree.

But you can set the document library to not open the files in the browser by default. Its in the Library settings > Advanced settings > Opening Documents in the browser > Open in client application

cheers, teylyn

Author

Commented:
That sucks!!
Is there any possibility to set so if under 2MB - open with Browser, and if over 2MB - open with Excel?

Author

Commented:
Or is there a way to increase the limit?
Most Valuable Expert 2011
Awarded 2010
Commented:
As far as I know that limit is not configurable. The setting whether or not to open in the browser or with the native app applies to the whole library. Maybe it ca be done with custom code, but I doubt it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial