Hello, I've been trying to work this out on my own for awhile now but I've hit a bit of a wall. I'm trying to get a table generated froma pivot table to update if the pivot is refresh and if data changes on that pivot. The first image shows three items owned by three different people. The first set is what was entered by myself, the second is the pivot generated by that set, the thrid is generated when I double click the grand total value.
Capture.PNG
Below I have updated the raw data and the pivot but I see no way to update the table that was created from the pivot. In my mind it stopping at the pivot does not really make ans sense to me. Am I missing something?
Capture2.PNG
I am using Excel 2016
Bookmarks