I have an excel spreadsheet (2007) that I have published to a dashboard as a Web Part. When I click the report opens fine and looks fine. However, I can not REFRESH the report data. I get the following error: Unable to retrieve external data for the following connections:
The database info is listed then it continues to state: Verify Data refresh in enabled (which it is) for the trusted file location and that the workbook data authentication is correctly set. (which it is) I am told be our administrator that all is set-up correctly, it must be my spreadsheet.
Sharepoint is 2007
Any ideas would be greatly appreciated.
The database info is listed then it continues to state: Verify Data refresh in enabled (which it is) for the trusted file location and that the workbook data authentication is correctly set. (which it is) I am told be our administrator that all is set-up correctly, it must be my spreadsheet.
Sharepoint is 2007
Any ideas would be greatly appreciated.