Pivot Refrest with New Data?
I have a file, including a pivot table, that I would like to use as a
"template" without having to regenerate the pivot table each time. In other
words, I would like to add to the data or replace the data and then just do
the equivalent of a refresh on the pivot table. Is this possible? From what
I've seen, the pivot table is locked into a certain range so if new data
doesn't fit the old range, portions of the data can be ignored. Any thoughts?
Thank you,
Will
|