'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing GROUPBY and REGEX Functions in Excel
Question details
The user is unable to access or use the newer GROUPBY and regular expression (REGEX) functions in Excel, despite being enrolled in the Microsoft 365 Beta Insider program.
- Product
- Microsoft Excel (Microsoft 365)
- Device & OS
- not provided
- Scenario
- Attempting to use the new GROUPBY and REGEX functions for data analysis in a Microsoft 365 Family subscription environment.
- Observed behavior
- The functions do not appear in the formula autocomplete suggestions and return errors when typed, indicating they are completely unavailable.
Ensure you have a stable internet connection to download the latest Microsoft 365 updates and verify that your Microsoft account is actively signed in to Excel.
Check Your Excel Version and Install Updates
Newer functions like GROUPBY and REGEX require specific Microsoft 365 builds (version 2406 or later). Forcing an update is the most common way to resolve missing features.
Microsoft rolls out new functions gradually based on your specific version and build number. If your software hasn't updated automatically, these functions will remain inaccessible.
Launch Microsoft Excel, click on the File menu in the top-left corner, and select Account from the left-hand sidebar.
Look under the Product Information section to see your current Version and Build number. Verify if it is older than version 2406.
Click the Update Options button and select Update Now from the drop-down menu to download and install the latest features.
Verify Microsoft 365 Beta Insider Enrollment
Because these functions are part of the preview experience, you must ensure your Insider account is actively configured to the Beta Channel.
Try WPS Office for a Reliable Spreadsheet Experience
Dealing with missing preview functions and complex update channels in Microsoft Office can be frustrating. WPS Office provides a free, lightweight, and highly compatible alternative with a rich library of stable built-in functions for all your data analysis needs—without forcing you into beta programs.
- 1. Download and Install: Download WPS Office from the official website and complete the quick installation process.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open any existing Excel workbook to continue your work without formatting loss.
- 3. Utilize Advanced Formulas: Access hundreds of robust, built-in functions via the Formulas tab to effortlessly calculate and analyze your data.
Frequently Asked Questions
Why can't I see the GROUPBY function in my Excel?
The GROUPBY function is rolling out to specific Microsoft 365 versions and is not available in older standalone versions (like Excel 2019 or 2021). You must have a supported Microsoft 365 build installed. Go to File > Account > Update Options to ensure your software is up to date.
Do I need a specific subscription to use new REGEX functions in Excel?
Yes, currently the new regular expression functions require active participation in the Microsoft 365 preview experience (Beta Channel) and you must be running version 2406 or later on a Microsoft 365 subscription.
What should I do if I am on the Beta Channel but still lack these functions?
Feature rollouts in the Microsoft Beta Channel are often phased, meaning not all Insiders get the feature at exactly the same time. If you meet all version requirements, you may simply need to wait until the feature is enabled for your account. Alternatively, try signing out and signing back into your Microsoft 365 account.
