|
|
#1
06-28-2023, 01:49 AM
|
|||
|
|||
"Cannot Group That Selection" issue with dates in Excel Pivot Table
I am getting the above error when I try and group dates in a pivot table (I want to have "Year" as a filter in the header)
I attach the list of dates and if you open the filter and scroll to the bottom, you will see that a number of dates are shown separately. I cannot see what is wrong, as they are formatted as Date. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
 Irritating formatting issue in Table of Contents - page number "dots" disappear
|
Eriks | Word | 9 | 04-19-2019 06:18 PM |
|
Pivot table dates issue
|
salse | Excel | 1 | 06-08-2016 12:23 PM |
| Excel Macro to "Select All" in Pivot Table Field | galkej | Excel | 0 | 02-03-2014 11:59 AM |
| Excel pivot table into an MS Word Doc "office 2007" | wmarsh3561 | Excel | 1 | 01-09-2010 08:03 PM |
Windows 10 
Office 2019
Threaded Mode