Grouped and ungrouped PivotTable column problem in Excel file

Grouped and ungrouped PivotTable column problem in Excel file

If you are using multiple PivotTables from the same data source, then there might be a problem (ungrouped PivotTable problem). The same column doesn’t work in a grouped and ungrouped state. At the moment, you are ungrouping grouped columns in other PivotTable, the same happening in other PivotTable.

Here is how to change grouping in one PivotTable without interaction with another.

Interrupt connection between PivotTables (ungrouped PivotTable problem)

  1. Copy that PivotTable which you want to copy.
  2. Open a new Excel file (Ctrl + N).
  3. Paste it there.
  4. Ungroup necessary column.
  5. Copy PivotTable with the ungrouped column.
  6. Paste it into the previous file.

Can’t properly copy PivotTable

Be careful with copying PivotTable – you should select all of it. The safest method is by going to the Analyze tab and using Select -> Entire PivotTable.

How to turn off auto grouping in PivotTable

Sometimes it might be better to turn that off.

Right now, in Office 365, go to:

  1. File
  2. Options
  3. Data
  4. Check “Disable automatic grouping of Date/Time columns in PivotTables”


How much you can do with PivotTable in 5 minutes?




Leave a Reply

Your email address will not be published. Required fields are marked *