Next Live Training Date:

9-13 Feb 2015 (JHB)

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.

Author: Adrian miric

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Handy Tips & Tricks

Accessing the task manager from excel

Accessing the task manager from excel A nice shortcut from @TomUrtis shows a quick way to get access the  Task Manager from Excel. Normally trying to access the Task Manager is a bad sign in Excel, and in fact you can’t do anything … Continue reading

Excel quiz answers- 11 Dec 2014

Excel Quiz Answers Answers for the quiz on our 11 Dec 2014 Newsletter. To subscribe to the newsletter visit the subscribe page. Excel Questions 1)   The biggest risk with linking spreadsheets together is a.   Rows and columns are added/ deleted when … Continue reading

AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.

– Sasol Polymers

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