STEP 5: Manually replace the incorrect dates with the correct dates: To make each incorrect cell easier to view go to Home > Fill Color ![]() STEP 4: Excel has now selected the incorrect dates. ![]() This will select all our invalid dates ( Errors) and text data ( Text). Make sure the Constants, Text, and Errors are selected. STEP 3: Go to Home > Find & Select > Go To Special: STEP 2: To check where our error occurred, go to the data table and highlight the column that contains our dates. However, we notice that we have an error! STEP 1:Right-click on any row in your Pivot Table and select Group so we can select our Group type that we want: In the example below I show you how to get the Errors when Grouping By Dates: So, the ideal step would be to look for those cells and fix them!īelow are the 2 Quick and Easy methods to find the cells containing invalid data and disappear the errors! Quick ways to Fix the “ Cannot group that selection” Error Pivot Table won’t allow you to group dates and you will get a cannot group that selection error. If even one of the cells contains invalid data, the grouping feature will not be enabled. ![]() The most common reason for facing this issue is that the date column contains either ![]() Reasons for “Cannot group that selection” Error in Excel Pivot Table Date Grouping FREE DOWNLOAD Analyze > Group Selection
0 Comments
Leave a Reply. |