Forum Discussion

dlang0302's avatar
dlang0302
Copper Contributor
Jun 18, 2022

data from web in mobile version of excel not updating

I currently use excel database to track my finances saved in One Drive and accessed through PC and mobile version. I created a table to update cryptocurrency prices from watchlist I shared from coinmarketcap.com. The table is set to update when I open as well as every 2 minutes. It works fine on PC version but mobile version only shows the last price updated on PC and never updates! Is there a way to fix the mobile version to update?  I had tried Cryptosheets before as well with same issue! Any help would be greatly appreciated!

 

PC Version Updating

PC Version Updating

 

Mobile Version Not Updating

Mobile Version No Update

 

4 Replies

    • dlang0302's avatar
      dlang0302
      Copper Contributor

      Thank you! Riny_van_Eekelen but why do most apps support things like this. It was the mobile version that it doesn't support right?

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        dlang0302 

        The problem is in authentication accessing external sources. So far Excel for web allows to refresh only queries based on the source within same file and OData source with anonymous access. More is coming...

Resources