Or, select the fourth option, for pivot tables that share the same pivot cache.
In Excel 2007, if you create two pivot tables from the same source data, they automatically use the same pivot cache of the source data.
When I tried to update the pivot table, it did not update.
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.
However, you might want different grouping in the two pivot tables.
Use the following easy method, suggested in the Excel newsgroups by Dave Peterson.
To create a separate pivot cache for the second pivot table: Now there are two pivot caches in the original workbook, and each pivot table can be grouped independently.