Duplicate of Grouping a field in one pivot tables groups the same field in another table, although the solution given there does not work in Excel 2013.

I want to have separate pivot tables so that I can filter and group the data separately in each. How can this be done?

2 Answers 2


Pressing ALT+D then P should open the PivotTable/PivotChart Wizard in Excel 2013

Another alternative is to click insert at the top and then you have the option of creating your own pivot table or selecting a recommended pivot table.

  • using insert to create pivot tables keeps formatting between them, even on Separate worksheets. Aug 8, 2016 at 8:48
  • It's not clear how your post tries to answer the question, please explain it. Aug 8, 2016 at 13:09
  • The OP wanted pivot tables and mentioned a solution in a previous post which I have said should work but offered an alternative Aug 8, 2016 at 13:15

Basically, when creating a pivot table, Excel makes a copy of the data source in a cache, which is then the source for the Pivot tables. (BTW: that's the reason why, when changing datas in your source, it doesn't actualize the Pivot table automatically).

Normally, Excel use the same cache for all pivot tables, if it comes from the same source. Having groups of fields in a pivot, impact therefore other pivot tables with the same field.

There is a however a workaround using the PivotTable/PivotChart Wizard

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .