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:    • Плейлист  

Or here are the links to individual videos; check them out!
Guide to Pivot Tables video:    • Beginners guide to Pivot Tables: lear...  
Introduction to Pivot Tables:    • Learn Pivot Tables in 7 Minutes | Int...  
Issues with PIVOT TABLES - fixing common errors:    • Issues with PIVOT TABLES - fixing com...  
Pivot Charts:    • Introduction to PIVOT CHARTS. Learn t...  
Pivot Tables and Slicers:    • Excel Pivot Table Slicers: Learn how ...  
How to Change the Pivot Table Field Viewing Options:    • How to Change the Pivot Table Field V...