'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel MAXIFS Showing as _xlfn.MAXIFS Error on Mac
Question details
The user needs to fix an issue where the MAXIFS function suddenly displays a #NAME? error with an _xlfn. prefix after a recent Office update.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Opening or editing a spreadsheet containing MAXIFS formulas following a Microsoft Office for Mac update.
- Observed behavior
- Excel automatically prefixes the MAXIFS formula with _xlfn. and returns a #NAME? error, even though the formula worked previously under the user's current license.
Before troubleshooting the licensing tool, confirm that your current Microsoft 365 or Office 2019/2021 subscription is actively linked to your account online, as the MAXIFS function explicitly requires a supported license version to run.
Completely Uninstall Office and Run the License Removal Tool
The most effective method when Excel loses access to newer functions like MAXIFS due to licensing or update corruption.
Update bugs can occasionally corrupt the local license tokens on a Mac, causing Excel to revert to a state where it no longer recognizes advanced formulas. Running the official License Removal Tool forces Office to fetch fresh, correct licensing data.
Open the Finder, navigate to your Applications folder, and drag Microsoft Excel, Word, PowerPoint, and Outlook to the Trash.
Download the official Microsoft License Removal Tool for Mac from the Microsoft support website. Open the downloaded .pkg file and follow the on-screen instructions to clear the corrupted license data.
Restart your Mac, download the latest Office installer from your Microsoft account, complete the installation, and sign in when prompted to reactivate your software.
Restart Mac and Re-enter the Formula
A quick fix to clear temporary caching issues affecting the formula namespace without needing a full reinstall.
Revert to a Previous Version of Microsoft Office
If a specific update introduced the bug, rolling back to an older working version will restore functionality until Microsoft patches the issue.
Use WPS Office as a Seamless, Error-Free Alternative
Avoid frustrating update bugs and licensing errors with WPS Office. It is a free, lightweight Microsoft Office alternative that offers high format compatibility, a familiar user interface, and seamless migration for all your spreadsheets, natively supporting advanced functions like MAXIFS.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer for your Mac.
- 2. Open your Excel file: Launch WPS Spreadsheets and open your existing .xlsx files effortlessly.
- 3. Calculate without errors: Edit your spreadsheets and use advanced formulas like MAXIFS with full native support.
Frequently Asked Questions
What does the _xlfn prefix mean in Excel?
The _xlfn prefix appears when a workbook contains a function that is not supported by the current version of Excel, or when the application temporarily fails to recognize the function due to underlying licensing or update issues.
Why did MAXIFS suddenly stop working after my Mac Office update?
Software updates can sometimes corrupt the license tokens or formula namespaces on a Mac. When this happens, Excel mistakenly drops support for newer functions like MAXIFS, which are strictly tied to Microsoft 365 or Office 2019 and later licenses.
Will running the Microsoft License Removal Tool delete my files?
No. The License Removal Tool only clears the hidden activation data and subscription tokens from your Mac's library folders. It does not touch, modify, or delete your saved workbooks or personal documents.
