Coding⏱️ 3 min read📅 2026-06-11

How to Fix: "Cannot group that selection" error when creating pivot table

Error fixing pivot table grouping issue with time data in unknown format.

Quick Answer: Convert time data to a standard format, such as 'HH:mm:ss', before creating the pivot table.

📋 Table of Contents

  1. ⚠️ Common Causes
  2. 🔧 Proven Troubleshooting Steps
  3. 💡 Conclusion

The 'Cannot group that selection' error occurs when attempting to create a pivot table and group the time column by hours. This issue affects users who have data with unformatted time values in their first column.

This error can be frustrating, especially when dealing with large datasets or complex formatting issues. In this guide, we will walk you through the steps to resolve this issue and create a functional pivot table.

⚠️ Common Causes

  • The primary cause of this error is that the time values in your dataset are not recognized as date/time format by Excel. This can happen when the data is imported from an external source or if the formatting has been altered during entry.
  • Another possible reason for this issue is that the time values are not aligned properly with the other columns, leading to incorrect grouping and sorting.

🔧 Proven Troubleshooting Steps

Aligning Time Values

  1. Step 1: Select all the cells containing unformatted time values. Right-click on any of these cells and select 'Format Cells'. In the Format Cells dialog box, go to the 'Number' tab and click on the 'Custom' category.
  2. Step 2: In the Custom category, enter `hh:mm:ss` (without quotes) as the number format. This will allow Excel to recognize the time values correctly. Click 'OK' to close the dialog box.
  3. Step 3: Save your workbook and try creating the pivot table again. The time column should now be recognized as a date/time format, allowing you to group by hours.

Editing Time Values Manually

  1. Step 1: Select all the cells containing unformatted time values. Right-click on any of these cells and select 'Format Cells'. In the Format Cells dialog box, go to the 'Number' tab and click on the 'Custom' category.
  2. Step 2: In the Custom category, enter `hh:mm:ss` (without quotes) as the number format. Click 'OK' to close the dialog box.
  3. Step 3: Alternatively, you can edit the time values manually by selecting any of the cells and entering the desired time format (e.g., 01:02:59). This will ensure that all time values are in a consistent format.

💡 Conclusion

By following these steps, you should be able to resolve the 'Cannot group that selection' error and create a functional pivot table. Remember to always check your data formatting when working with date/time values in Excel.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Stuck in tutorial hell after 4 years: How do I b

Fix Stuck in tutorial hell after 4 years: How do I bui. Practice build

How to Fix: Trying to sync mutliple audio tracks to a movie

Fix Trying to sync mutliple audio tracks to a movie bu. Consider using

How to Fix: Failed to merge latest branches from upstream re

Fix Failed to merge latest branches from upstream repo. Try running 'g