I have an excel document that connects to a SQL Server database. When I generate the excel document the connection automatically refreshes the information when the workbook opens.
When I try to put this in an EXCEL WEB PART the connections fails with the following:
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.
Any ideas what I shoud be looking for in order to get this resolved? I know I have permissions to the data connections because I can refresh them manually from the Data Connection library.
Asny assist is greatly appreciated.
When I try to put this in an EXCEL WEB PART the connections fails with the following:
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.
Any ideas what I shoud be looking for in order to get this resolved? I know I have permissions to the data connections because I can refresh them manually from the Data Connection library.
Asny assist is greatly appreciated.