Next Live Training Date:

15-19 Feb, 14-18 Mar 2016

Pivot Table group dates by month cannot group that selection

Pivot Table group dates by month cannot group that selection

Pivot Tables for Excel 2007A very frustrating aspect of PivotTables is where you receive a message that Pivot Table group dates by month cannot group that selection. This also happens when you try other groupings.

The reason for this seems to be how Microsoft Excel sees the data.

For example if you have 999 cells that contain a valid Excel date, and only 1 cell that is a blank or a date that excel doesn’t recognise you will get the message that ‘Pivot Table group dates by month cannot group that selection’.

To get the PivotTable to perform the grouping you will need to change the problem cells to more acceptable entries. Change blanks to a zero or dates into Excel acceptable dates.

Dates are often a problem in PivotTables so we often recommend that clients create a new column in the underlying data that does any of the grouping they need and then pull through these grouped columns into the Pivot Table.

Subscribe to our free newsletter covering Excel tips tricks & shortcuts

Please fill in your details below to receive the free monthly Audit Excel newsletter which covers free Excel tips tricks and shortcuts.

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

AE Newsletter: Sum only visible cells, put m2 into a cell, changing away from R1C1 format

Sum only visible cells, put m2 into a cell, changing away from R1C1 format If we have helped you before with some of our tips and tricks, please forward this link to your friendsĀ and suggest they subscribe. If we have … Continue reading

Summing, Counting, or Averaging visible cells only

Summing, Counting, or Averaging visible cells only in Excel Often when you use tools like filter, grouping or hiding rows in Excel you want to be able to do the summing, counting or averaging of the visible cells only. Alternatively … Continue reading

I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.

– Melco Conveyor Equipment (Pty) Ltd

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients