'%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 GROUPBY and PIVOTBY Missing in Excel for the Web
Question details
The user is trying to use the new GROUPBY and PIVOTBY functions in Excel for the Web, but the functions are unrecognized or entirely missing.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to group or pivot data dynamically using worksheet formulas in the browser-based version of Excel.
- Observed behavior
- The GROUPBY and PIVOTBY functions are unavailable and return an error when typed, despite being announced on official Microsoft blogs.
Ensure you are signed into your Microsoft 365 account using a supported and fully updated web browser (such as Microsoft Edge or Google Chrome).
Check Microsoft 365 Release Channels and Updates
Since these functions are deployed gradually, you must verify your rollout channel and monitor official releases to know when they will be available for your account.
Microsoft does not release new web functions to all users, organizations, or regions simultaneously. Features are usually pushed to 'Targeted Release' users before moving to the 'Standard Release' channel.
Make sure your browser is up to date. Go to your browser settings and clear the cache, as an outdated cached version of the web app might prevent newly rolled-out functions from appearing.
If you are using a work or school account, your IT administrator manages your update channel. Contact your IT admin to find out if your organization is enrolled in the Targeted Release track for early feature access.
Visit the official Microsoft 365 Roadmap website and search for 'Excel' to track the deployment status of specific formulas. Release dates for Excel for the Web are not usually announced in advance outside of this roadmap.
Analyze Data Seamlessly with WPS Office
Tired of waiting for new function rollouts in Excel for the Web? You can easily organize, group, and pivot your data right now using the robust desktop version of WPS Spreadsheet. WPS Office is a completely free, lightweight alternative that offers comprehensive data analysis tools and identical formatting compatibility, saving you from browser limitations.
Frequently Asked Questions
Why do some users have the GROUPBY function in Excel while I do not?
Microsoft pushes updates to users in phases. Those enrolled in the Beta or Targeted Release channels receive new functions weeks or even months before those in the Standard Release track.
Can I force Excel for the Web to update?
No. Because Excel for the Web is hosted on Microsoft's servers, updates are applied automatically on their end. The only action you can take is to clear your browser cache to ensure you aren't loading a stale version of the site.
What can I use instead of PIVOTBY if the function is missing?
If you need to pivot data and the formula is unavailable, you can use the traditional PivotTable feature. Select your data, go to the 'Insert' tab on the ribbon, and click 'PivotTable' to summarize your dataset.
