Function Problems

Why GROUPBY and PIVOTBY Are Missing in Microsoft 365 Excel

Steve K Sep 28, 2026 869 views

Question details

Users are unable to locate or use the GROUPBY and PIVOTBY dynamic array functions in Microsoft 365 Excel despite having an updated version.

Why GROUPBY and PIVOTBY Are Missing in Microsoft 365 Excel

Product: Microsoft 365 Excel
Device & OS: not provided
Scenario: Attempting to summarize and analyze data directly within cell formulas using the new advanced dynamic array functions.
Observed behavior: The GROUPBY and PIVOTBY functions return a #NAME? error and do not appear in the formula autocomplete drop-down menu.

Before you start

Verify that you are logged into your Microsoft 365 account and ensure your subscription is currently active before checking for new feature updates.

Solution 1Recommended

Verify Your Microsoft 365 Update Channel

Determine if your current Excel update channel has received the new functions yet.

The GROUPBY and PIVOTBY functions were initially released to beta testers. If your Excel installation is on the standard Current Channel, these functions may not be available until Microsoft initiates a general rollout.

Open Account Settings

Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Account' from the left sidebar.

Locate Update Information

Look for the 'Product Information' section on the right side of the screen. Under 'About Excel', note your current channel and build number.

Check Channel Status

If your channel says 'Current Channel' rather than 'Beta Channel', the functions have not yet been rolled out to your version. You will need to wait for Microsoft's official general release.

Verify Your Microsoft 365 Update Channel

Release Schedule: Microsoft rolls out features gradually, meaning even users on the same channel might receive updates at slightly different times.

Solution 2

Join the Microsoft 365 Insider Program

Switch to the Beta Channel to gain early access to GROUPBY, PIVOTBY, and other upcoming functions.

Free Microsoft Office alternative

Use WPS Office for Reliable Data Analysis

While waiting for new Microsoft 365 functions to roll out globally, try WPS Office. It provides a lightweight, completely free alternative with powerful PivotTables and dynamic data analysis tools that do not rely on beta update channels.

1. Download and Install: Download WPS Office from the official website and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file without worrying about formatting issues.
3. Use PivotTables: Go to the 'Insert' tab and click 'PivotTable' to easily group, pivot, and summarize your data instead of relying on missing formula arrays.

Completely free to use with no subscription requiredFully compatible with Microsoft Excel .xlsx and .xls formatsBuilt-in advanced PivotTable features for quick data summarizationFamiliar user interface allows for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Are GROUPBY and PIVOTBY available in Excel 2019 or Excel 2021?

No. The GROUPBY and PIVOTBY functions are exclusive to Microsoft 365 subscriptions and Excel for the Web. Standalone lifetime licenses like Excel 2019 and 2021 will not receive these function updates.

How can I group data without using the GROUPBY function?

If you do not have access to GROUPBY, you can use traditional PivotTables to group and summarize your data. Alternatively, you can combine standard dynamic array functions like UNIQUE and SUMIFS to replicate similar behavior.

Why am I getting a #NAME? error when typing =GROUPBY?

The #NAME? error occurs because your current version of Excel does not recognize the function. This confirms that the feature has not yet been enabled for your specific update channel or Microsoft 365 build.

Excel & Data Problems