'%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)
Fix GROUPBY and PIVOTBY Functions Missing in Microsoft 365 Excel
Question details
The user is unable to find the new GROUPBY and PIVOTBY functions in Microsoft 365 Excel, despite update release notes stating they are included.
- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Attempting to use newly released data analysis functions (GROUPBY and PIVOTBY) in Microsoft 365 Excel.
- Observed behavior
- The functions are completely unavailable or return a #NAME? error, likely due to delayed feature availability across update channels or gradual account rollouts.
Verify that you have an active Microsoft 365 subscription, as the GROUPBY and PIVOTBY dynamic array functions are not available in perpetual standalone versions like Office 2019 or Office 2021.
Check Your Update Channel and Manually Update Excel
Manually triggering a software update ensures your Microsoft 365 installation is running the latest build required to access the new functions.
Feature availability in Microsoft 365 heavily depends on your specific update channel (e.g., Current Channel vs. Semi-Annual Enterprise Channel). Updating manually forces Excel to pull the latest releases designated for your channel.
Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom-left menu.
Under the 'Product Information' section, click the 'Update Options' drop-down button and select 'Update Now'.
Wait for the update process to finish. Once complete, completely close and restart Excel, then type =GROUPBY( into a cell to check if the function is available.
Wait for the Gradual Account Rollout
Microsoft deploys new functions in phases, meaning the feature is enabled on an account-by-account basis even after the software update is installed.
Try WPS Office for a Reliable and Fast Spreadsheet Experience
Tired of waiting for phased feature rollouts and dealing with subscription updates? WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office. It offers powerful data analysis tools and pivot table functionalities that are ready to use the moment you install it.
- 1. Download the Software: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the installer and follow the simple on-screen instructions to complete the setup in minutes.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and effortlessly open your existing Microsoft Excel files to continue your work without missing a beat.
Frequently Asked Questions
Why are GROUPBY and PIVOTBY missing even after I fully updated Excel?
Microsoft frequently uses a phased rollout approach for new dynamic array functions. Even if your software is fully updated to the correct build, the functions are enabled on the server side gradually. It may take a few extra days for your specific account to receive them.
Can I use GROUPBY and PIVOTBY in Excel 2021 or 2019?
No, these dynamic array functions are exclusive to Microsoft 365 subscribers. Standalone perpetual licenses like Office 2021 or Office 2019 will not receive these feature updates.
How do I check which Microsoft 365 update channel I am currently on?
Open Excel, navigate to File > Account, and look under the Product Information section. You will see your assigned update channel (such as Current Channel or Semi-Annual Enterprise Channel) listed directly below the 'About Excel' heading.
