Forum Discussion

James_Price's avatar
James_Price
Brass Contributor
Jan 15, 2025

Query updates in a browser

Hi team,

Does anyone know when we can get Excel Queries updated through a browser without physically opening Excel.  I can't believe it's not been done by know by now.

Many thanks 

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.

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor

    through a browser

    What do you mean through a browser?

    Do you want to update an Excel file on remote server like MS Forms?

    • James_Price's avatar
      James_Price
      Brass Contributor

      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 

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        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.

Resources