How to Restore Missing Excel Functions Like MAXIFS and SEQUENCE
Question details
The user is encountering a #NAME? error because newer Excel functions like MAXIFS and SEQUENCE are missing or unrecognized after switching to a new Mac.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Trying to use modern dynamic array or advanced statistical functions on a newly set-up Mac computer.
- Observed behavior
- Excel fails to compute the formula and displays a #NAME? error, indicating that the functions are not recognized by the installed version.
Before troubleshooting, ensure you are logged into Excel with the Microsoft 365 account that includes your subscription, as these newer functions require an active subscription to work.
Update Microsoft Excel to the Latest Version
Newer functions like MAXIFS and SEQUENCE require the latest version of Microsoft 365. Updating your Excel installation usually resolves missing function issues.
When switching to a new Mac, the installed version of Excel might be out of date. The #NAME? error specifically means the application does not recognize the function text, which is typical when trying to use dynamic array functions on an older build.
Close Microsoft Excel completely by pressing Cmd + Q or selecting Quit from the application dock.
Reopen Excel, click on the 'Help' menu at the top of the screen, and select 'Check for Updates' to launch Microsoft AutoUpdate.
Click the 'Update All' button or the specific 'Update' button next to Excel to install the latest Microsoft 365 patches.
Once the update is complete, restart your Mac. Open Excel and test your formulas again to confirm the #NAME? error is resolved.
Use Manual Formulas as a Temporary Workaround
If you cannot update Microsoft 365 immediately, you can recreate the sequence using basic addition formulas.
Verify Your Microsoft 365 License Details
Excel will only provide premium functions if you are signed in with an active Microsoft 365 account.
Access Advanced Formulas with WPS Office for Free
If your Excel version doesn't support the latest dynamic array formulas or you want to avoid expensive Microsoft 365 subscriptions, switch to WPS Office. It is a lightweight, free alternative that offers robust formula support and seamless compatibility with your existing spreadsheets.
- 1. Download WPS Office: Visit the official WPS Office website to download and install the free software on your Mac.
- 2. Open Your Excel File: Launch WPS Spreadsheet, click 'File', and select 'Open' to load your existing .xlsx document with the missing formulas.
- 3. Continue Editing Smoothly: Enjoy full spreadsheet functionality and continue working on your data with a familiar interface and zero learning curve.
Frequently Asked Questions
Why does Excel show a #NAME? error for MAXIFS?
This error occurs when Excel does not recognize the function name. It usually means you are using an older version of Excel that doesn't support the MAXIFS function, you don't have an active Microsoft 365 subscription, or there is a typo in the formula text.
Are dynamic array functions like SEQUENCE available in Office 2019?
No, dynamic array functions such as SEQUENCE, FILTER, and UNIQUE are only available to Microsoft 365 subscribers and users who have purchased Office 2021 or newer.
How do I check my Excel version on Mac?
To check your version, open Excel, click on 'Excel' in the top menu bar, and select 'About Microsoft Excel'. A window will appear displaying your exact version number and your current license type.
