We've recently upgraded from SharePoint 2007 to 2010 and we are trying to get the Excel Web Access web part to work.
Excel Services is running if that's required, the workbook location is configured to be trusted, and when linking a Workbook to the web part, this displays
The full message is below, even though a Workbook is selected.
To display a workbook in this Web Part, you must first select the workbook.
To select a workbook, open the tool pane, and then edit the Workbook property
Question: Does anyone have an idea of what is causing this?
It may be related, but if I try to open the Workbook in the Excel Web Access (not the web part) I receive this message.
I've tried to look this up and most things say to check permissions based on error messages, but there are no messages in the Event Viewer. This is similar to Excel Services 2010 Error - "The workbook cannot be opened." but none of the solutions work.
There is an Excel Services Proxy running and Office Web Apps is enabled on the site collection.
Any suggestions on how to fix this?