When Will the FILTER Function Be Available in Excel for Microsoft 365?
Question details
The user wants to know when the Excel FILTER function will be available in Excel for Microsoft 365 for their organization or region.

- Product
- Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- The user is checking documentation and update channels because the FILTER function was announced but has not appeared in their Excel installation.
- Observed behavior
- The feature is not yet available for every Microsoft 365 user, and no single release date applies to all accounts, regions, or organizations.
Check your current Microsoft 365 update channel and Excel version before troubleshooting the missing FILTER function, because feature availability is tied to the update channel and rollout settings.
Check Your Office Update Channel and Apply Latest Updates
Use this first to see whether your account is on a channel that has received the FILTER function and to install any pending updates.
The FILTER function is released gradually across Microsoft 365 update channels. Users on the Current Channel or Monthly Enterprise Channel often receive new Excel functions earlier than users on Semi-Annual channels, but availability can still vary by region and tenant.
Open Excel for Microsoft 365, select File > Account, and note the Update Channel and Excel version shown under Product Information.
Select Update Options > Update Now, then allow Excel to download and install any available updates.
Restart Excel, open a workbook, and enter =FILTER( to check whether the function is now available.

Ask Your Administrator or Switch to a Faster Update Channel
Use this when your organization manages Office updates and you need to know whether a channel change can make the FILTER function available sooner.
Use WPS Office as a Free Spreadsheet Alternative While You Wait for the Excel FILTER Function
When the Microsoft 365 FILTER function is still not available in your Excel installation, WPS Office offers a free, lightweight spreadsheet and Office suite. It is compatible with Excel .xlsx files, presents a familiar spreadsheet UI, and lets you keep working with your workbooks without waiting for Microsoft's rollout.
- 1. Download WPS Office: Go to the WPS Office download page and install WPS Office for Windows, Mac, Android, or iOS.
- 2. Open your Excel workbook: Launch WPS Spreadsheets and open your existing .xlsx workbook directly.
- 3. Continue working with familiar formulas: Use Excel-style formulas and features in WPS Spreadsheets while your Microsoft 365 tenant waits for the FILTER function.

Frequently Asked Questions
Why is the FILTER function missing from my Excel for Microsoft 365 even though it is documented?
There is no single release date for every user. Availability depends on your Microsoft 365 update channel, account settings, organization policies, and region. Check File > Account > Update Options > Update Now to install any pending updates.
How can I check which Microsoft 365 update channel I am on?
In Excel, select File > Account. Under Product Information, you can see the Update Channel and Excel version. You can also contact your Microsoft 365 administrator to confirm tenant rollout settings.
Can changing my Office update channel make the FILTER function appear faster?
It may help if your organization allows channel changes. Channels such as Current Channel or Monthly Enterprise Channel often receive new functions earlier, but the rollout still depends on Microsoft, region, and tenant policies.
Is WPS Office a free alternative for opening and editing Excel workbooks while I wait?
Yes. WPS Spreadsheets opens and saves Excel .xlsx files and provides a familiar spreadsheet interface. Download WPS Office Free, open your workbook, and continue working without waiting for the Excel FILTER rollout.




