I have a BI Center site, I'm trying to open an Excel sheet in the PivotView gallery but it gives me this error:
Workbook cannot be opened
I have uploaded the Excel sheet in another library but it still gives the same error message.
Also when I open the Excel sheet using client application it works fine.
How do I fix this?
I'm using the same excel sheet again. I'm fetching data from an SP list using Odata feed connection; http://sharepointsite/_vti_bin/listdata.svc In the connection properties I set it to "None" so that it uses SSS
In central Admin > Application Management > Manage Service Application > Secure Store Service, I have created a new targetd application ID, members: domain users and set the credintials to an account that has access on the list data (has access on sharepoint site in general) then I upload the excel to sharepoint to open it in web view, I refresh the data connection to fetch new data but I get this error everytime:
External Data Refresh Failed: An error occurred while working on the Data Model in the workbook. Please try again.
We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh:
DataFeed connection_name listdata
External Data ajeso Information Failed to create an external connection or execute a query. Provider message: Out of line object 'DataSource', referring to ID(s) '', has been specified but has not been used. The following system error occurred: Class not registered The provider 'Microsoft.Mashup.OleDb.1' is not registered. , ConnectionName: ThisWorkbookDataModel, Workbook: Book1.xlsx.
Failed to create an external connection or execute a query. Provider message: Out of line object 'DataSource', referring to ID(s) '', has been specified but has not been used. Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: The remote name could not be resolved: 'sharepointsite'. , ConnectionName: ThisWorkbookDataModel, Workbook: Book2.xlsx.