Microsoft Office Tutorials and References
In Depth Information
Appendix A: Troubleshooting
Data Refresh Failed
Unable to retrieve external data for the following connections:
The data sources may be unreachable, may not be responding, or may have denied
Verify that data refresh is enabled for the trusted file location and that the
workbook data authentication is correctly set.
How do I ensure a secure and valid refresh operation?
If you are able to refresh data from the Excel client, the most common case for this error message is that
the data access is not configured correctly on the server. Chapter 5 explains how to set up data access.