Function Problems

Fix Excel FILTER Function Missing on Mac Microsoft 365 Trial

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is unable to find or use the FILTER function (and potentially other advanced functions) in Microsoft Excel for Mac, despite running an active Microsoft 365 trial and updating to version 16.92.

Product: Microsoft Excel
Device & OS: Mac
Scenario: Attempting to use advanced array functions like FILTER during a Microsoft 365 trial on a Mac.
Observed behavior: The FILTER function is completely missing or fails to work correctly in the workbook.

Before you start

Make sure your Mac has an active internet connection so Microsoft Excel can verify your subscription status.

Solution 1Recommended

Restart Mac and Verify Microsoft Account Details

Refreshing your system and confirming your login details often forces Excel to sync with your active Microsoft 365 trial, restoring premium functions.

Restart Your Mac

Save your work, click the Apple logo in the top-left corner of your screen, and select 'Restart' to clear temporary background errors.

Reopen Microsoft Excel

Launch the Excel application from your Mac's Dock or Launchpad.

Verify Account Sign-In

Click 'Excel' in the top menu bar, select 'Sign In' or 'Account', and ensure you are logged into the exact Microsoft account associated with your Microsoft 365 trial.

Test the Function

Open a new workbook and type '=FILTER(' into a cell to check if the function now appears in the autocomplete suggestions.

Solution 2

Repair or Reinstall Office for Mac

If account verification does not restore missing functions like FILTER, IFS, SWITCH, or LET, your Office installation may be corrupted and requires reinstallation.

Free Microsoft Office alternative

Try WPS Office as a Reliable Alternative for Mac

Tired of dealing with missing functions, trial glitches, and subscription verifications? WPS Office is a powerful, free alternative to Microsoft Office that provides a stable spreadsheet experience natively on Mac without complicated trial restrictions.

1. Download the App: Visit the official WPS Office website and download the Mac version.
2. Install WPS Office: Open the installer and drag the WPS Office icon into your Applications folder.
3. Open Your Workbooks: Launch WPS Spreadsheet and open your existing Excel files to continue working seamlessly.

Includes a comprehensive set of advanced spreadsheet functions for seamless data analysis.Highly compatible with Microsoft Excel (.xlsx) file formats, ensuring zero formatting loss.Lightweight design that runs incredibly fast and smoothly on macOS.Free to use with a familiar, intuitive user interface that makes switching effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the FILTER function only available in Microsoft 365?

The FILTER function is part of the dynamic arrays feature set, which Microsoft introduced exclusively for Microsoft 365 subscribers and Excel 2021. Older standalone versions like Excel 2019 do not support these functions.

Are dynamic array functions included in a free trial?

Yes, an active Microsoft 365 trial includes all premium features. As long as your trial is active and correctly signed in on your Mac, you should have full access to dynamic arrays like FILTER, LET, and XLOOKUP.

What should I do if my trial is active but functions are still missing?

First, ensure your Mac is connected to the internet to validate your trial license. If the functions are still missing, logging out of your Microsoft account within Excel and logging back in usually resolves the synchronization issue.

Excel & Data Problems