31 October, 2013

This workbook is larger than the maximum workbook size allowed to be opened in the browser

Today we faced one more new issue and it was quite easy to understand and predict what will be the resolution! But today’s article is especially for those who are business managers/IT analyst/vice presidents/governance etc. - who does have access to the servers.

To display a workbook in an Excel Web Access Web Part, you must add the Web Part to a page and then connect the workbook to the Web Part by entering the workbook URL or UNC in the Excel Web Access tool pane. As a final step, you can customize the Web Part by selecting properties in the Excel Web Access tool pane for the Web Part.

User reported an issue that he is trying an excel file in the excel web access webpart (EWA) and getting the following error message-
This workbook is larger than the maximum workbook size allowed to be opened in the browser.
 
Here is the step by step resolution:
1)     Open the central administration
2)     Application management
3)     Manage service applications
4)     Excel service application
5)     Click on Trusted File locations
6)     Select the document library link where your excel files are stored
7)     Go to the section termed as “Workbook Properties”
8)     Maximum workbook size
9)     By default its set to 10MB
10) Set it as per your requirement – like 50MB/100MB
11) Click OK


Go back to your site now where you were facing the problem -> refresh the page and check the results!

It should be resolved now. Thank you.

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.

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.