Internal limit error be showed when open an excel with owa

Question

_{Friday, November 18, 2016 8:47 AM}

Upload an excel file (size is 300KB) and click excel to open with excel web apps, it was open fine. But moment after, I clicked to view again, it cannot be open, and error is "The file you selected cannot be open because of an internal limit that has been exceeded". But others excel file can be open fine. The log only record this message and no detail information, so I want to know what value is limit.

My Farm environment: SharePoint 2013 and Office Web apps server 2013

All replies (6)

_{Tuesday, November 29, 2016 7:23 AM ✅Answered}

It was solved by install sp1.

_{Friday, November 18, 2016 4:59 PM}

Hi C.S- this is odd that others don't have this problem. Normally I'd say you've surpassed the web app limit, but you're certainly under that (10mb). It could also be that the file has a lot of data validation cells or calculations, but that should be a problem for everyone. I suggest you clear your browser cache and check out the following link for more you can try:

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/08/13/excel-services-large-workbook-error/

cameron rautmann

_{Monday, November 21, 2016 4:04 AM}

Thanks for your response. The error be showed when everyone opened excel file. But I upload this excel to a test environment it was fine. Production and test environment are same configuration.

_{Tuesday, November 22, 2016 8:25 AM}

Hi C.S Prince,

Did the issue only occur in one excel file?

To troubleshoot the issue, you could check things below:

1. clear SharePoint configuration cache. For more detailed information, you could refer to the article below.

Clearing the Configuration Cache for SharePoint.

http://www.sharepointpitstop.com/2013/09/clearing-configuration-cache-for.html

2. Clear office web app cache. For more detailed information, you could refer to the article below.

The Office Web Applications Cache.

https://blogs.technet.microsoft.com/wbaer/2010/09/01/the-office-web-applications-cache/

3. create a new library and upload the excel file to check if the same issue will occur.

More reference:

SharePoint 2013: Troubleshooting Office Web Apps.

http://social.technet.microsoft.com/wiki/contents/articles/16179.sharepoint-2013-troubleshooting-office-web-apps.aspx

Best regards,

Sara Fan

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

_{Monday, November 28, 2016 8:33 AM}

Sara,

Thanks for your response. I try it again and found excel has a sheet has more column and rows, total cells more than 20000, so that cannot be open. Which value i need to increase for resolve this issue?

_{Tuesday, November 29, 2016 7:35 AM}

Hi C.S Prince,

It is very happy that you have resolved your problem.

Thank you for your sharing and it will help others have the same issue.