Function Problems

Fix Missing Excel PIVOTBY Function in Microsoft 365

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is trying to use the new PIVOTBY function in Microsoft 365 Excel but finds it missing or unavailable in their application.

Product: Microsoft 365 Excel
Device & OS: not provided
Scenario: Attempting to summarize spreadsheet data using the newly released PIVOTBY function.
Observed behavior: The PIVOTBY function does not appear in the formula autocomplete list and returns an error when typed, typically due to the user's Microsoft 365 update channel not yet receiving the feature.

Before you start

Ensure you have an active Microsoft 365 subscription, as the PIVOTBY function is not available in standalone perpetual versions like Office 2021 or 2019.

Solution 1Recommended

Switch to the Current Update Channel

Microsoft releases new Excel functions gradually. Switching from the Semi-Annual Channel to the Current Channel can make new functions like PIVOTBY available immediately.

New Microsoft 365 features are often released to the Current Channel months before they reach the Semi-Annual Channel used by many organizations.

Open Product Information

Launch Excel, click on 'File' in the top-left corner, and select 'Account' from the left sidebar to view your software details.

Check Your Update Channel

Look under the 'About Excel' section to see your current update channel. If it displays 'Semi-Annual Enterprise Channel', the PIVOTBY function is likely not yet rolled out to you.

Update the Channel

Click 'Update Options' and select 'Update Now'. If you are on a managed corporate device, you may need to ask your IT administrator to switch your device to the 'Current Channel'.

IT Administrator Restrictions: Feature availability can vary by release and tenant. If you are on a work computer, your organization's IT policies might restrict you to the Semi-Annual channel for stability purposes.

Free Microsoft Office alternative

Try WPS Office for Powerful Data Analysis

If your Microsoft 365 version is restricted by corporate update channels and you cannot access new features, consider switching to WPS Office. It provides comprehensive data analysis tools, including highly capable PivotTable functionalities, completely free of charge.

1. Download WPS Office: Visit the official WPS website to download and install WPS Office Free on your device.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files seamlessly with zero formatting loss.
3. Analyze Your Data: Navigate to the Insert tab and use the native PivotTable feature to dynamically group and summarize your data as an alternative to the PIVOTBY function.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Free, lightweight, and fast alternative to Microsoft 365.Includes standard built-in PivotTable and data summary features.No complex corporate update channels—get full features immediately.

microsoft office alternative - wps office

Frequently Asked Questions

Will the PIVOTBY function eventually come to the Semi-Annual Channel?

Yes, Microsoft rolls out new features to the Semi-Annual Enterprise Channel a few months after they debut on the Current Channel. You simply need to wait for the next scheduled major update.

Can I manually download and install the PIVOTBY function?

No, Excel functions like PIVOTBY are integrated directly into the core application updates of Microsoft 365. They cannot be downloaded individually or installed as separate add-ins.

Does the PIVOTBY function work on Excel 2021 or 2019?

No, PIVOTBY is an exclusive feature for Microsoft 365 subscribers. It will not be made available in standalone, perpetual license versions of Excel like 2021 or 2019.

Excel & Data Problems