mrchonginhk
Well-known Member
- Joined
- Dec 3, 2004
- Messages
- 679
I have a PowerQuery PQ1 get data from Sheet1
Then PQ2 is based on PQ1
PQ3 is based on PQ2
In the past when I change data in Sheet1
Refresh PQ3 will display new data
Now I do the same in another different xlsx file like this approach above
However, after changing data in Sheet1,
Refresh PQ3 does not update any change...
I have to refresh PQ1, PQ2 and then refresh PQ3 then I can see the new updated result
How can I make it only refreshing PQ3 would take into consideration of the change of data in Sheet1 ?
What do I need to check ? Please help
Thanks
Then PQ2 is based on PQ1
PQ3 is based on PQ2
In the past when I change data in Sheet1
Refresh PQ3 will display new data
Now I do the same in another different xlsx file like this approach above
However, after changing data in Sheet1,
Refresh PQ3 does not update any change...
I have to refresh PQ1, PQ2 and then refresh PQ3 then I can see the new updated result
How can I make it only refreshing PQ3 would take into consideration of the change of data in Sheet1 ?
What do I need to check ? Please help
Thanks