External Data Refresh Failed on Web Excel Version

Question

Hi,

I have encounter the refresh issue on web excel version, tried search around but not able to find the right answer to fix.

Please help.

Error Showing,

We were unable to refresh one or more data connections in this workbook.
The following connections failed to refresh:
Query - Data

Thank you

Answer 1

Not all data refresh are supported in Excel for the web, it's depending on how your environment is configured. Please refer to this support article and check if you can refresh data in Excel desktop app:

refreshing-data-in-a-workbook-in-a-browser-window-89560193-0c11-420b-b7d8-744766ccdc94