Excel Shows _xlfn Prefix After Microsoft 365 Update: Fix

After a Microsoft 365 update, you may open an Excel workbook and see formulas displaying a strange _xlfn. prefix, such as _xlfn.TEXTBEFORE or _xlfn.XLOOKUP. This happens because the workbook contains functions from a newer version of Excel that your current build does not yet support, or the file was saved in a format that strips function compatibility. This article explains exactly why the _xlfn. prefix appears, provides step-by-step methods to remove it, and covers related scenarios where this issue persists.

Why the _xlfn. Prefix Appears After an Update

The _xlfn. prefix is Excel’s way of marking a function that it does not recognize in the current workbook. When Microsoft 365 releases a new function, older Excel builds or file formats that cannot store the function name natively will prefix it with _xlfn. to preserve the formula logic. Three common triggers cause this:

Outdated Microsoft 365 Build

Even though you just updated, your channel (Current, Monthly Enterprise, Semi-Annual) might not include the newest functions. Functions like TEXTSPLIT, TEXTBEFORE, TEXTAFTER, and VSTACK were added gradually across channels. If your build is on a slower update channel, Excel may not have the function definitions yet.

File Saved in Compatibility Mode (.xls)

When you save a workbook as an Excel 97-2003 (.xls) file, Excel converts all modern functions to their _xlfn. equivalents because the older binary format cannot store the new function names. Reopening the file in a modern Excel version still shows the prefix.

Workbook Created in a Newer Build Then Opened in an Older Build

If you share a workbook with someone on an older Excel 2016 or 2019 build, or if you open the same file on a different device that has not received the update, Excel inserts the _xlfn. prefix to indicate unsupported functions. The function does not calculate until the file is opened on a compatible version.

Steps to Remove the _xlfn. Prefix From Formulas

The following methods resolve the prefix issue in most cases. Start with Method 1 because it addresses the root cause.

Method 1: Update Microsoft 365 to the Latest Build

1. Open Excel and go to File > Account
   Under Product Information, click Update Options and then select Update Now. Excel will check for the latest build and install it automatically.
2. Restart Excel after the update completes
   Close all open workbooks and reopen the file with the _xlfn. prefix. If the prefix remains, proceed to Method 2.

Method 2: Save the Workbook in .xlsx or .xlsm Format

1. Open the affected workbook
   Press F12 to open the Save As dialog.
2. Change the file type to Excel Workbook (.xlsx) or Excel Macro-Enabled Workbook (.xlsm)
   From the Save as type dropdown, select Excel Workbook (xlsx) if your workbook contains no macros. If it contains VBA macros, select Excel Macro-Enabled Workbook (xlsm). Click Save.
3. Close and reopen the file
   Exit Excel completely, then open the newly saved .xlsx or .xlsm file. The _xlfn. prefix should disappear because the modern file format supports the new function names natively.

Method 3: Use Find and Replace to Manually Remove the Prefix

This method is a workaround when the prefix remains due to a corrupt cell reference or a workbook that was created in a very old build. It does not fix the underlying compatibility issue, but it cleans up the display.

1. Select the range that contains the _xlfn. formulas
   If the entire sheet is affected, click the triangle at the intersection of the row numbers and column letters to select all cells.
2. Press Ctrl+H to open the Find and Replace dialog
   In the Find what box, type _xlfn. (including the period). Leave the Replace with box empty. Click Replace All.
3. Verify the formulas recalculate
   After replacement, press Enter on any affected cell to see if the formula evaluates correctly. If the cell shows a #NAME? error, the function is still not supported in your Excel build. Revert the change by pressing Ctrl+Z and use Method 1 or 2 instead.

If the _xlfn. Prefix Still Appears After the Main Fix

Excel Displays _xlfn. Prefix After Saving as .xlsx

If you saved the file as .xlsx and the prefix remains, the workbook likely contains formulas that reference external add-ins or custom functions that use the _xlfn. prefix internally. Check the formula bar for any function that starts with _xlfn. that is not a built-in Excel function. These custom functions require the add-in to be installed on the current computer. Install the missing add-in or replace the formula with a native equivalent.

Excel Shows _xlfn. Prefix After Copying Data From Another Workbook

When you copy a cell containing a modern function from a workbook created in a newer Excel build, the prefix may travel with the formula. Use Paste Special > Values to paste only the result, then re-enter the formula manually in the destination workbook. This avoids bringing over the _xlfn. prefix.

_xlfn. Prefix Appears in Excel for Mac or Excel Online

Excel for Mac and Excel Online may lag behind the Windows desktop version in supporting new functions. If you open a workbook created on the Windows desktop with functions like TEXTSPLIT or PIVOTBY, the prefix appears. On Mac, ensure you are on the latest Insider or Current channel build. On the web, the function may simply not be available yet. Use alternative formulas, such as combining LEFT, RIGHT, and MID with SEARCH, to replace the unsupported function.

Quick Update vs Full Reinstall: Key Differences

Item	Update via File > Account	Full Reinstall of Microsoft 365
Time required	5 to 15 minutes	30 to 60 minutes
Internet needed	Yes, downloads missing patches only	Yes, downloads entire installer
Effect on settings	Preserves all add-ins and customizations	Resets add-ins and may require reactivation
Fixes missing function definitions	Yes, if the channel includes the function	Yes, installs the latest available channel build
Recommended for _xlfn. prefix	First step	Only if update fails or channel is locked

The _xlfn. prefix is a compatibility marker, not a bug. By updating your Microsoft 365 build to the latest version and saving your workbook in the modern .xlsx format, you can remove the prefix and restore full function calculation. If the prefix persists after these steps, check whether the function is available in your specific update channel or consider replacing it with a supported alternative. Use the Compatibility Checker under File > Info > Check for Issues to see a full list of unsupported functions before sharing the workbook with users on older Excel versions.