Forum Discussion
Query updates in a browser
James_Price , so far in Excel for Web we may refresh only queries with source in the same file or anonymous OData. Refresh for other queries is only promised, current ETA is
However, we are waiting for this more than a year, target date is moving to the right from time time.
through a browser
What do you mean through a browser?
Do you want to update an Excel file on remote server like MS Forms?
Hi Peiyezhu
The Excel file is stored in SharePoint and I access it through a browser. I have an option to open in browser or open in app. If I open in the browser, I can't update using the Data tab, then Queries and refresh. Considering everything has moved to the cloud and the number of people who use this feature, I can't believe that this is not available by now and no one has a clue when it will be available.
Hope this helps,
James
James_Price , so far in Excel for Web we may refresh only queries with source in the same file or anonymous OData. Refresh for other queries is only promised, current ETA is
However, we are waiting for this more than a year, target date is moving to the right from time time.
Nice one. Thanks for the update Sergei. I missed this rollout item.
James
https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104
Re:If I open in the browser, I can't update using the Data tab, then Queries and refresh.
I think you can edit in browser if the file saved in one drive or sharepoint.