Any time you close then re-open the file, the pivot table will be refreshed.To set this up: The final way to update the pivot table is with programming.Because you created the two pivot tables from the same source data, by default they use the same pivot cache, which is where the grouping is stored.
The Pivot Table has built in filtering tools that can be used to fine tune the results shown by the Pivot Table.
Filtering data involves using specific criteria to limit what data is displayed by the Pivot Table.
Refer to a Pivot Item of a Pivot Field present in a Pivot Table directly using a VBA Macro 6.
Remove old (ghost) Items from a Pivot Table using VBA Macro 7.
It would be nice if a pivot table automatically updated, whenever its source data changes, but unfortunately, that doesn’t happen.
If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised data right away.
You can use Excel VBA to automatically update a pivot table when its worksheet is activated.
There are instructions on my Contextures website, for copying VBA code to your own files.
As you add the field names to the data areas, your data is added to the pivot table.
Depending on which fields are placed in which data area, different results can be obtained.
Pivot Play Plus01It shows the connection string, and allows it to be changed.