Hi Excel Gurus,
I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2).
In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the pivot table.
Is there a better way to design it so that the pivot/table ranges and refresh doesnt disappear?
(tab 1) - Original data. On this data, I have placed a power query - deleting the first 6 rows, and making the data into a table named range.
(tab 2) - Pivot table based on the power query
I dont really want to link it to a location, as the location and file name changes very often. I would also like to see the original dataset visually within the spreadsheet.
Hope this makes sense.
thank you.
I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2).
In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the pivot table.
Is there a better way to design it so that the pivot/table ranges and refresh doesnt disappear?
(tab 1) - Original data. On this data, I have placed a power query - deleting the first 6 rows, and making the data into a table named range.
(tab 2) - Pivot table based on the power query
I dont really want to link it to a location, as the location and file name changes very often. I would also like to see the original dataset visually within the spreadsheet.
Hope this makes sense.
thank you.