Showing posts with label that's a big workbook. Unfortunately. Show all posts
Showing posts with label that's a big workbook. Unfortunately. Show all posts

08 April, 2014

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.

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.


Error message#2:
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.

Resolution:
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