Problem
description:
One
user has reported an issue where he was getting an error while accessing the
excel files from SharePoint site.
Before
contacting the user, I tried uploading one dummy excel file to check the behavior
and it works fine so I thought it might user who is doing some mistake. Further
probing on the issue, I got the following details.
Entities:
1. SharePoint
2013
2. Excel
2013 / Office 2013
3. Internet
explorer 8.0
How to reproduce
this error?
a) Upload your excel
document in the document library
b) Try to open this
document by directly clicking on it or excel dropdown ->view in browser.
c) You will get the
following error:
Error Message#1:
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.
Couldn't Open the Workbook. Wow, that’s a big workbook.
Unfortunately, we can't open a workbook larger than 10MB. You'll need to open
this in Excel.
Error message#3:
The form submission cannot be processed because it exceeded the
maximum length allowed by the web administrator. Please resubmit the form with
less data.
a) Central
administration
b) Application
management
c) Service
applications
d) Manage
service applications
e) Excel
Services Application
f) Trusted
File locations
g) Select
the document library where your web part is failing
h) Refer
the section named as “workbook properties”
i) Change
the maximum workbook size
j) By default
its 10MB
k) Change
it to 50MB / 100MB as per your requirement
l) Click
OK.
If
you have any queries/questions regarding the above mentioned information then
please let me know. I would be more than happy to help you as well as resolves
your issues, Thank you.
Note:
If you find a different solution, please report it as a comment to
this post. Be sure to double-verify it: undo your solution and verify that the
problem comes back, then redo it and verify that the problem goes away.
Product applies to:
1. SharePoint
2013
2. SharePoint
Foundation 2013
3. SharePoint
2010
4. SharePoint
Foundation 2010