Function Problems

How to Fix GROUPBY Function Missing in Excel Version 2308

Nimra Malik Oct 9, 2026 871 views

Question details

Users are unable to find or use the GROUPBY function in Microsoft Excel version 2308.

How to Fix GROUPBY Function Missing in Excel Version 2308

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use the new GROUPBY function for data aggregation and summarization.
Observed behavior: The GROUPBY function does not appear in the formula autocomplete list and returns a #NAME? error when typed manually, as it is not included in the standard update channel for version 2308.

Before you start

Ensure you have an active Microsoft 365 subscription and administrative rights on your computer, as changing update channels requires proper permissions.

Solution 1Recommended

Join the Microsoft 365 Insider Beta Channel

The GROUPBY function was rolled out initially to Beta Channel users. Joining the Insider program gives you early access to this and other experimental features.

Microsoft releases new functions like GROUPBY and PIVOTBY to the Beta Channel for testing before rolling them out to the general public. Switching to this channel will force an update to the latest preview build.

Open Account Settings

Launch Microsoft Excel and click on "File" in the top-left corner, then select "Account" from the bottom-left menu.

Join Microsoft 365 Insider

Look for the "Microsoft 365 Insider" section on the right side of the screen. Click the button and select "Join Microsoft 365 Insider".

Select the Beta Channel

In the pop-up dialog, check the box to sign up for early access, click the "Choose your Insider channel" drop-down menu, and select "Beta Channel". Agree to the terms and click "OK".

Update Excel

Return to the Account page, click the "Update Options" button, and select "Update Now". Excel will download the latest Beta build, which includes the GROUPBY function.

Join the Microsoft 365 Insider Beta Channel

Organization Restrictions: If you are using a work or school account, your IT administrator may restrict access to the Insider program. You will need to contact them to enable Beta channel access.

Solution 2

Update Current Channel or Use PivotTables as an Alternative

If you cannot join the Beta channel, ensure your current channel is fully updated, or rely on standard PivotTables for similar functionality.

Free Microsoft Office alternative

Try WPS Office for Powerful Data Analysis and Spreadsheets

If you are tired of dealing with specific version requirements, restricted update channels, or missing features in Microsoft Excel, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that offers robust data analysis tools, including PivotTables and a vast array of built-in functions to handle complex data aggregation effortlessly.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Install the Software: Run the setup file and follow the quick installation prompts to set up WPS Office on your computer.
3. Open Your Spreadsheets: Launch WPS Spreadsheets, click "Open", and select your existing Excel (.xlsx) files to continue your data analysis without losing any formatting or data.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Includes powerful data analysis tools like PivotTables and advanced filtering.Free to download and exceptionally lightweight on system resources.Familiar user interface requires no learning curve or retraining.

microsoft office alternative - wps office

Frequently Asked Questions

When will the GROUPBY function be available to all Excel users?

The official release date for the General or Current channel depends on Microsoft's rollout schedule. It typically takes several months after the initial Beta Channel release for a function to be thoroughly tested and pushed to the standard update channels.

Does my Microsoft 365 license type affect the availability of new functions?

Yes. Perpetual licenses like Office 2019 or Office 2021 do not receive new feature updates and will not get the GROUPBY function. You need an active Microsoft 365 subscription to receive continuous feature rollouts.

Can I use the PIVOTBY function if GROUPBY is missing?

No. Both GROUPBY and PIVOTBY were announced and released simultaneously in the Beta channel. If your Excel version lacks GROUPBY, the PIVOTBY function will also be unavailable.

Why does the GROUPBY function return a #NAME? error?

The #NAME? error occurs when Excel does not recognize the function name. This means your current version of Excel does not support the GROUPBY function yet, or there is a typo in your formula syntax.

Excel & Data Problems