Forum Discussion
Pivot Table: Grouping doesn't work (tried almost everything)
Hi community, I'm trying to use the "group" function in PivotTables but it always says "cannot group the selected area", without further information. I've strictly followed Microsoft's instruction an...
Most often that happens if you have texts which looks like dates or numbers. "formated everything consistently (no text, only numbers..." won't help. If you apply, for example, date format to text like "07/01/2026" it still will be text, not actual date.
How exactly did you veryfy if there is text or blank space instead of numbers? Checked cell by cell with ISNUMBER or ISTEXT; or transform possible texts to numbers with Text to Columns; or checked values alignment visually; or something else?