Next Live Training Date:

13-17 July, 17-21 Aug

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.

Handy Tips & Tricks

Link Excel to PowerPoint

Link Excel to PowerPoint (or Word) A common requirement in the business world is to link parts of an Excel file into PowerPoint (or Word) in such a way that when the Excel file is updated, the PowerPoint (or Word) … Continue reading

MIRR in financial models

MIRR in financial models MIRR in financial models is potentially a better way to determine the return on an investment than the typical IRR. It stands for the Modified Internal Rate of Return and its actual workings are better explained … Continue reading

I can testify that since I have been trained by you online, I really improved my Excel knowledge. But as you know, I am not living in South Africa but I am in Democratic Republic of Congo.

Please let me know if you have an online version of this session and I will be part of it.

– Congo

Video Library & Tutorials //

View Entire Video Gallery ››

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

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients