In Excel 2007, when you create a second pivot table from the same source data, you dont get an option to base the new pivot table on an existing pivot table, the. Excel Pivot table tutorial shows how to create a dynamic source so new data is automatically included when pivot table is refreshed.