- Jan 4, 2021
- Office Version
I have an excel file with several Queries, however when opened from Sharepoint via browser the Refresh All Data fails for all of my Queries. Specifically, the error is "External Data Refresh Failed - We were unable to refresh one or more connections in this workbook. The following connections failed to refresh." These queries are all internal with a connection type of OLE DB Query. My only solution right now is to open the file in the desktop application, refresh the data, and then save it again so that all of the users who access this document can see the latest data. Any ideas?