Forum Discussion

Willy Lau's avatar
Willy Lau
Steel Contributor
Nov 23, 2018
Solved

A Question about Power Query

The current Excel version I use does not have power query feature. I know it is better than formula to extract data in complex case. However, I would like to know whether I need to click "Refresh" to ...
  • Haytham Amairah's avatar
    Nov 23, 2018

    Hi Willy,

     

    The query doesn't get updated automatically like the formulas.

    So you need to hit the Refresh button each time you update the data source.

    That's true for the Pivot Tables as well!

     

    Regards

Resources