Pivot Table Sort Data Updates

[aallsschmidt]

When applying Pivot Table functionality to a set of raw data is very useful, however I am unable to refresh the raw data and it flow through to the existing pivot table. Are you not able to edit the raw data and it flow through to the existing pivot table. Even if I try to create a new pivot table with the revised raw data, the data change does not flow through. Can you explain why this is happening? How can you create pivot tables and refresh to reflects the latest in your dynamic raw data set?

 

[GraH]

If the raw data is inside a proper excel table, then it is straightforward working.
If it is a range, then you'd need to revert to a dynamic range formula using index or offset.
Plenty of examples on the net are available.