Function Problems

How to Fix Missing FILTER and SEQUENCE Functions in Excel 365

Amos Gikunda Oct 15, 2026 869 views

Question details

The user is unable to find or use the FILTER and SEQUENCE dynamic array functions in their Excel 365 application.

How to Fix Missing FILTER and SEQUENCE Functions in Excel 365

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Attempting to use dynamic array formulas for data sorting, filtering, or sequence generation in a spreadsheet.
Observed behavior: The functions are completely unavailable, missing from the ribbon, or failing to compute, possibly returning a #NAME? error.

Before you start

Ensure you have an active internet connection to download any pending Microsoft 365 updates and save your current workbook progress before making changes to your account settings.

Solution 1Recommended

Check Account Details and Update Microsoft 365

Dynamic array functions require the latest Microsoft 365 updates. Checking your account version and forcing an update often restores these missing features.

In many cases, an outdated update channel or a delayed enterprise rollout is the primary reason why newer features like FILTER and SEQUENCE fail to appear.

Open Account Settings

Launch Microsoft Excel, click on 'File' in the top-left corner of the interface, and select 'Account' from the bottom of the left-hand navigation menu.

Verify License and Update Channel

Under 'Product Information', verify that you have an active Microsoft 365 subscription. Check your current 'Update Channel' to ensure you are not on a restricted or heavily delayed enterprise channel.

Install Updates

Click on the 'Update Options' button located next to Office Updates, and select 'Update Now' from the dropdown menu to download and install the newest features.

Test the Functions

Once the update finishes, restart Excel, open a new blank workbook, and type '=FILTER(' into any cell to verify that the function is now recognized.

Check Account Details and Update Microsoft 365

Update Successful: Once updated, other advanced dynamic array functions like SORT, UNIQUE, and XLOOKUP will also become available for use.

Solution 2

Add Missing Sort & Filter Commands via Ribbon Customization

If the underlying functions work but the specific Sort & Filter command buttons are missing from your toolbar, you can manually restore them.

Free Microsoft Office alternative

Experience Seamless Spreadsheets with WPS Office

Struggling with missing features, delayed updates, or enterprise license restrictions in Microsoft 365? WPS Office offers a powerful, lightweight, and completely free alternative. Enjoy high compatibility with all your Excel files and a familiar interface without the hassle of subscription bugs.

1. Download WPS Office: Visit the official WPS website and download the free installer designed for your computer's operating system.
2. Install the Software: Run the downloaded installer and follow the straightforward on-screen instructions to set up the WPS Office suite.
3. Open Your Workbooks: Launch WPS Spreadsheet and open your existing .xlsx files directly. You can continue working immediately without losing formatting or data.

Completely free and lightweight spreadsheet solutionFully compatible with Microsoft Excel (.xlsx, .xls) formatsFamiliar user interface requiring zero learning curveSmooth migration of your existing workbooks and formulas

microsoft office alternative - wps office

Frequently Asked Questions

Why do my existing FILTER functions show a #NAME? error?

The #NAME? error occurs when Excel does not recognize the function text. This happens if you open a workbook containing dynamic array functions on a version of Excel that does not support them, or if your Microsoft 365 update channel has rolled back to an older build.

Can I use FILTER and SEQUENCE in Excel 2016 or 2019?

No, the FILTER and SEQUENCE functions are part of the dynamic arrays update, which is exclusive to active Microsoft 365 subscribers and users who have purchased the standalone Excel 2021 or newer editions.

What should I do if my organization restricts Microsoft 365 updates?

If your Excel Account page indicates that updates are managed by your system administrator, you must contact your IT department. They can check your update policies and potentially move your account to the Current Channel to receive dynamic array features.

Excel & Data Problems