If a data query fails to refresh in Excel online, the cause should be identified.
The error message gives a link to a page that lists the possible causes, but why can't the error message just tell you what's causing YOUR query not to refresh? It would really speed up troubleshooting.
I also have this issue. Several queries on a single sheet and they all fail but no guidance on how to set Sharepoint for the file to actually refresh the data.
It works flawlessly on the desktop app. All URLs are visible from the WWW (not LAN)
I need more guidance.