Refresh queries from Excel Online
We would like suggest you enable feature of refreshing the query on the excel online app.
User created a file that creates/refreshes a query into a SharePoint site, all works fine when you are under Excel desktop app, but if you open the same file an try to refresh queries from Excel Online, it throws an error saying the external data refresh failed.
It would seem that having the capability to refresh a query would be a common feature not specific to the desktop version. This is a bit disappointing, and makes online Excel a less attractive product.