Function Problems

Why Are Excel PIVOTBY and GROUPBY Functions Missing & How to Fix It

Khadija Khan Oct 1, 2026 868 views

Question details

The user is unable to locate the new PIVOTBY and GROUPBY functions in Microsoft Excel despite having an active subscription and installing the latest software updates.

Why Are Excel PIVOTBY and GROUPBY Functions Missing?

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use new dynamic array functions for data analysis and aggregation in Microsoft 365.
Observed behavior: The PIVOTBY and GROUPBY functions do not appear in the formula autocomplete dropdown list and return a #NAME? error if typed manually into a cell.

Before you start

Verify that you have an active Microsoft 365 subscription and are signed into your account, as these new dynamic array functions are not available in perpetual license versions such as Office 2021 or Office 2019.

Solution 1Recommended

Check Microsoft 365 Insider Channel Enrollment

PIVOTBY and GROUPBY functions are initially rolled out exclusively to Microsoft 365 Insiders. You must join the appropriate Insider program channel to gain early access to these features.

New Microsoft Excel functions are typically tested in the Beta Channel or Current Channel (Preview) before general release. Keep in mind that features are rolled out gradually to subsets of users, meaning that joining the Insider program does not always guarantee immediate access.

Open Account Settings

Launch Microsoft Excel, create a blank workbook, and click on 'File' > 'Account' located at the bottom left corner.

Join Microsoft 365 Insider

Look for the 'Microsoft 365 Insider' button under your product information. Click it and select 'Join Microsoft 365 Insider' from the dropdown menu.

Select the Beta Channel

In the prompt that appears, check the box to sign up for early access, then choose the 'Beta Channel' from the dropdown list and accept the terms and conditions.

Update Microsoft Excel

After joining, click the 'Update Options' button in the Account menu and select 'Update Now'. Once the update is installed, restart Excel and try typing =PIVOTBY( in a cell.

Check Microsoft 365 Insider Channel Enrollment

Gradual Feature Rollout: If you have joined the Beta Channel and updated your app but still cannot find the functions, you simply need to wait. Microsoft progressively enables these features on their backend over weeks or months.

Solution 2

Test Availability in Excel for the Web

Microsoft often tests new formula functions in the web version of Excel before or concurrently with the desktop app's Beta channel.

Free Microsoft Office alternative

Experience Powerful Data Analysis with WPS Office

If you are frustrated by the slow rollout of new features in Microsoft 365 or need a reliable spreadsheet tool immediately, WPS Office offers a robust, highly compatible alternative for advanced data summarization.

1. Download WPS Office: Visit the official WPS Office website and click the free download button for your operating system.
2. Install the Software: Run the downloaded installer file and follow the quick on-screen instructions to set up WPS Office on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel files to analyze and pivot your data instantly.

Seamless format compatibility with Microsoft Excel (.xlsx, .xls, .csv) filesComprehensive built-in PivotTable and grouping features for dynamic data summarizationFamiliar ribbon user interface requiring zero learning curve for Excel usersFree to download and use with a lightweight, resource-friendly installation package

microsoft office alternative - wps office

Frequently Asked Questions

When will PIVOTBY and GROUPBY be available to all Microsoft 365 users?

Microsoft has not announced a specific general availability date. These functions usually transition from the Beta Channel to the Current Channel only after extensive testing and feedback collection.

Are the PIVOTBY and GROUPBY functions available in Office 2021?

No. PIVOTBY and GROUPBY are exclusive to Microsoft 365 subscriptions and Excel for the Web. Perpetual license versions like Office 2021 or 2019 will not receive these new dynamic array functions.

What should I do if I joined the Beta channel but the functions still result in a #NAME? error?

Features in the Beta channel are rolled out progressively to small subsets of users. You simply need to wait and keep your Microsoft 365 apps updated until the feature is activated for your specific account.

Can I use standard PivotTables instead of the PIVOTBY function?

Yes, standard PivotTables can achieve the same data summarization and grouping results. While PIVOTBY offers a dynamic, formula-based approach that updates instantly as source data changes, a standard PivotTable remains a fully capable alternative.

Excel & Data Problems