Pivot Table Issues

Fix Missing Year and Month Date Grouping in Mac Excel Pivot Tables

Maira Mehtab Sep 30, 2026 869 views

Question details

Users are unable to group dates by Year and Month in Excel for Mac PivotTables after a recent software update.

How to Fix Missing Year and Month Date Grouping in Excel PivotTables for Mac

Product: Microsoft Excel for Mac
Device & OS: macOS
Scenario: Attempting to group date fields into separate levels (like Year and Month) within a PivotTable.
Observed behavior: The Group Selection feature creates one large group instead of categorizing the data into standard separate date levels.

Before you start

Ensure you have your Microsoft account credentials handy and save a backup copy of your current workbook before attempting to roll back your Office version.

Solution 1Recommended

Revert to an Earlier Build of Excel for Mac

Since this is a known bug in recent updates (such as version 16.86), rolling back to a previous stable release is the most effective temporary workaround.

Reverting to a previous software build will restore the normal PivotTable grouping functionality until Microsoft releases an official patch.

Uninstall Current Office

Open Finder, go to the Applications folder, locate Microsoft Excel, and drag it to the Trash.

Download Previous Version

Visit the official Microsoft Office for Mac update history page and download an earlier version installer (for example, a version prior to 16.86).

Install and Disable Auto-Updates

Run the downloaded installer. Once installed, open Excel, go to Help > Check for Updates in the top menu bar, and uncheck 'Automatically keep Microsoft Apps up to date' to prevent the bug from returning.

Revert to an Earlier Build of Excel for Mac

Avoid Security Risks: While rolling back is an effective workaround, remember to periodically check community forums to see if a newer, stable version has been released that patches both security flaws and this specific bug.

Solution 2

Update Excel and Report the Issue

Microsoft frequently releases patches for known bugs. If a newer update doesn't fix it, reporting the issue helps expedite a permanent solution.

Free Microsoft Office alternative

Use WPS Office to Seamlessly Analyze Data with Pivot Tables

Avoid update bugs and compatibility issues with WPS Office. It provides a lightweight, free alternative to Microsoft Office with a highly compatible spreadsheet application, ensuring your PivotTables and data analysis work flawlessly on Mac.

1. Download WPS Office: Visit the official WPS website and download the Mac version of WPS Office.
2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx file directly without needing to convert it.
3. Insert a Pivot Table: Select your data range, navigate to the Insert tab on the ribbon, and click PivotTable.
4. Group Your Dates: Right-click the date field inside the generated PivotTable and select Group to easily categorize your data by Year and Month.

Highly compatible with Microsoft Excel (.xlsx) formatsStable PivotTable grouping features including dates, numbers, and textFree and lightweight suite designed for smooth performance on MacFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel PivotTable date grouping stop working on Mac?

This is a known software bug introduced in a recent Microsoft Excel for Mac update (around version 16.86), which disrupts the standard date grouping hierarchy and groups all dates into one large block.

Will I lose my data if I revert to an older version of Excel?

No, your spreadsheet files and underlying data are saved independently of the application and will remain safe. However, it is always recommended to back up your important workbooks before uninstalling or modifying software versions.

Can I manually group the dates instead of using the automatic feature?

Yes. As a workaround, you can manually create helper columns in your source data using formulas like =YEAR(A2) and =MONTH(A2) to extract the specific date parts. You can then drag these new helper columns into your PivotTable to achieve the same result.

How do I stop Excel from automatically updating again after I roll back?

Open Excel, navigate to Help > Check for Updates on the top menu bar, click on the Advanced options (or directly on the update screen), and turn off the automatic update setting to ensure you stay on your current stable build.

Excel & Data Problems