PivotTable and PivotCharts

[Craig]

I update our headcount report monthly and I have built
multiple tabs of reports pointing to the master data. If I
replace the master data information all the tabs should
update when I click the ! Refresh Data on each tab,
correct?

 

[Frank Kabel]

Hi
this is correct But it seems you have encountered problems with
that?

 

[Debra Dalgleish]

To ensure that all the new data is included in the pivot table, you
could base the pivot table on a dynamic source. There are instructions here:

http://www.contextures.com/xlPivot01.html