Hi Excel Gurus,
I created a spreadsheet...
(tab 1) - Source Data (OLD data)
(tab 2) - Source Data (NEW data)
(tab 3) - Power query to combine (tab 1+2) Old and new data
(tab 4) - I have created a pivot table based on the Power Query (tab 3).
Now when I update the data in tab 1 & 2, the Power query in tab 3 updates successfully, but the pivot tables does not (tab 4).
Is there a way to connect the pivot table successfully so that when I click "Refresh All", all data updates in the tab 3 & 4?
hope that makes sense.
thanks
I created a spreadsheet...
(tab 1) - Source Data (OLD data)
(tab 2) - Source Data (NEW data)
(tab 3) - Power query to combine (tab 1+2) Old and new data
(tab 4) - I have created a pivot table based on the Power Query (tab 3).
Now when I update the data in tab 1 & 2, the Power query in tab 3 updates successfully, but the pivot tables does not (tab 4).
Is there a way to connect the pivot table successfully so that when I click "Refresh All", all data updates in the tab 3 & 4?
hope that makes sense.
thanks