I am having a problem with a workbook I am trying to display in a SharePoint 2013 site. When I attempt to view the workbook in the Excel Web Access web part I get the following error "Couldn't Open the Workbook - The workbook cannot be opened." However, if I open the workbook in the browser or excel it works fine. The workbook does contain cell references to another workbook, but to test if this was the issue I placed another workbook in the site with no references, just a plain workbook with a few test values, and it will not display in the web part either. 

I've read about similar problems where the solution was to grant permission to the Excel Services Account but I am not getting the error on other sites in the same web application? Could anything else be causing this error to occur?

Thanks for your time!

Hi,

would you please check whether location of your library is added as trusted file location under excel service application under central admin.

Hi,

Could you please tell where did you store the original excel workbook?

If you create a new page and use Excel web access web part to display the workbook, does it work?

If the issue persists, please reproduce the issue and collect ULS log for troubleshooting.

https://technet.microsoft.com/en-us/library/ff463595%28v=office.15%29.aspx

Regards,

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

try these links:

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2014/03/18/quot-the-workbook-cannot-be-opened-quot.aspx

http://www.sharepoint2013.me/Blog/Post/395/Excel-service-exception-in-SharePoint-2013--Excel-services-won%27t-open-in-excel-document

http://www.sharepoint2013.me/Blog/Post/395/Excel-service-exception-in-SharePoint-2013--Excel-services-won%27t-open-in-excel-document

http://sharepointcherie.blogspot.in/2013/06/sharepoint-2013-excel-services-wont.html

http://sharepointcherie.blogspot.in/2013/06/sharepoint-2013-excel-services-wont.html

---------------------------------------------------------------------------------------------------------------------------

Please mark as answer if you find it useful else vote for it if it is close to answer..happy sharepointing

Okay, updates on my progress:

I granted content database access to the managed account as described in most of the articles on this error. I doubted this was the problem as other site collections are working fine, but this did in fact solve my problem - at first. Once I got the dashboard working I saved the site as a template and churned out 14 more sites - when I added the new workbooks and linked them to the webpart they broke, giving me a new error "Couldn't Open the Workbook - We're sorry, we couldn't open your workbook. - It's possibly corrupt or using a file format that's not supported - Do you want to try and open this file in Excel?" Now these documents won't open in web part or browser view, but they open just fine in the client. 

So, checked the ULS logs and nothing is coming up Unexpected, Critical, etc - not in the web or app servers - nothing. 

So I started with the first suggestion by Ibraham K. I listed the entire site collection and all it's children as a Trusted File Location. The reason I went so far is the site collection has 52 'Office' subsites, each having it's own excel workbook that is aggregating up to 15 'roll-up' excel workbooks in the 'Division' subsites. 

The 15 'roll-up' workbooks have references to the office workbooks that are relevant to that 'Division.'

Also made sure that xlsx wasn't listed as a blocked file type - not that I thought it would be. Tried downloading the workbook, deleting it out of SharePoint and re-uploading to no avail. I'm sure I tried some other things I'm missing...

Oh, and the first site that I used as a template once I got it working the first time - doesn't work anymore. 

Been banging my head against a wall all day...

The only ULS entry over medium is a monitorable event when opening the file in browser: WOPI (CheckFile) Proof Data: AccessToken Hash '-384927669' [1035 bytes], URL 'HTTP://[webapp]/PROCESS/BUDGETPLANNING/COMMEA/_VTI_BIN/WOPI.ASHX/FILES/79C9FC89CD4640DC85B9E0160819342C?ACCESS_TOKEN=EYJ0EXAIOIJKV1QILCJHBGCIOIJSUZI1NIISING1DCI6IMZYY000RG04VXBREXHGQTFCRFH1SKU2MFZKDYJ9%2EEYJHDWQIOIJ3B3BPL3D3DY5TEW1HCNRHLMNVBUBJOTE1NMQ0ZI1LYMI3LTRJMMITOTG1ZI1JMZNKNJHJZTNHYJIILCJPC3MIOIIWMDAWMDAWMY0WMDAWLTBMZJETY2UWMC0WMDAWMDAWMDAWMDBAYZKXNTZKNGYTZWJINY00YZJILTK4NWYTYZMZZDY4Y2UZYWIYIIWIBMJMIJOIMTQYMJY2OTU1NYISIMV4CCI6IJE0MJI3MDU1NTCILCJUYW1LAWQIOIIWIY53FG1HCNRHXFXKZ29VZHJPZGDLIIWIBMLPIJOIBWLJCM9ZB2Z0LNNOYXJLCG9PBNQILCJPC3VZZXIIOIJ0CNVLIIWIY2FJAGVRZXKIOIIWKS53FHMTMS01LTIXLTEYMZA4NZA5MY0YNTQXNJG3MDI5LTE1MJQZMTGWMTYTMJKXOTMILCJPC2XVB3BIYWNRIJOIVHJ1ZSISIMFWCGN0ECI6IJC5YZLMYZG5Y2Q0NJQWZGM4NWI5ZTAXNJA4MTKZNDJJOZJIDURYCUPYEWX3ZEXKNZZXDTIVB2L1BDHRBZ07RGVMYXVSDDS7NDAWMDAXRJA3RKZGMUJGRJTUCNVLIN0%2EGHXRLMBKACGTAYJJGBFUZY8QUW%2DIPOP2FXYFCYWYG7DGMFKVF313GTYRDAZS8ZYEVQYZ%2DFLHERQWJ6CQOXZXQ3P7DSBHKT86H1KFE%5F5E0R3UT7V5YDRYXTEITRNT7THFAZBVFCDGHVLGBZZ9F8A3A%2DZUOMQDRMQ9GAFDNZMOZIJFT85CXC1D%5FLLBECF6KX1IU%2DDXFOWTIVLJT%5F6TMUAWYCWAUONLOX1LGY%2D2SCFKSOTHW1GY8TKFUXCUUCF6WRMOAK%2DRABMQH6AX8XVO1SXXXPP1DJUPKO2SVH%5FE%2DZ5E%5FHHINHWRG%5FKS9YQ9Z5PTQNNPNOCJ60DVDRKJQNATK9P2WG&ACCESS_TOKEN_TTL=1422705557144' [1220 bytes], TimeStamp '635582663578604427' [8 bytes]  CALLER-[machine: VSPIOWA01, version: 15.0.4481.1000, CorrelationId: 1f004c10-cf94-475b-9e11-8e8bf377bb55]

• Edited by itdgoodridge Saturday, January 31, 2015 2:11 AM added additional details