How to Fix "Cannot Group Selection" Error in Pivot Table (Excel tutorial)

Learn how to fix the "Cannot Group Selection" error in pivot tables in Excel and Google Sheets. This common error occurs when there are invalid dates or numbers in your data. In this video, we'll show you a simple method to identify and fix the problem so you can start grouping your data and getting the insights you need.
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
You can find all our Pivot Table videos in the following playlist: • Playlist
Or here are the links to individual videos; check them out!
Guide to Pivot Tables video: • Beginners guide to Piv...
Introduction to Pivot Tables: • Learn Pivot Tables in ...
Issues with PIVOT TABLES - fixing common errors: • Issues with PIVOT TABL...
Pivot Charts: • Introduction to PIVOT ...
Pivot Tables and Slicers: • Excel Pivot Table Slic...
How to Change the Pivot Table Field Viewing Options: • How to Change the Pivo...

[@daneshsharrma8855]

Great video, exactly what I was looking for. Have a great day!

[@BitesizeExcel]

So happy that it helped! Hope you have a great day to and let me know if there are any other videos you'd like to see! 😄

[@pickypocky]

Thank you for the tutorial, ur video really helped me solve the problem

[@BitesizeExcel]

Glad it helped!

[@greyling77]

thank you lifesaver

[@BitesizeExcel]

Glad it helped! Xx

[@rahuladvisor]

awesome

[@BitesizeExcel]

Glad you found this useful! :)

[@johndurran614]

Excellent video but sound quality not great

[@BitesizeExcel]

Yes - I was having some microphone issues and trouble adjusting with my software. I'll have another go later in the week and might re-upload the video if I get it resolved.

[@controlledchaos365_]

still same error comes up

[@BitesizeExcel]

I'll have a little play around and see if there is an alternative solution for you!

[@apamwamba]

Same with me. seems like a bug

[@BitesizeExcel]

Sadly I haven't been able to replicate this continuing error. But if I find a potential alternative solution I will let you know!

[@apamwamba]

Looks like you have to uncheck all third party add-ons and check them in again. Sometimes they interfere with excel. It worked for me.

[@BitesizeExcel]

@@apamwamba Thanks for this - really useful tip to know!