If an expense workbook shows #NAME? or a formula with _xlfn in front of a function name on another computer, that computer's Excel does not know the function. XLOOKUP, FILTER, LET, LAMBDA and several newer ones only exist in Excel 2021 and Microsoft 365. The fix is to swap them for older equivalents such as INDEX and MATCH, or SUMIFS, before you send the file.
Why does the workbook break on another computer?
A workbook stores the formula, not the answer. When the other person's Excel opens it, it recalculates. If it meets a function it has never heard of, it cannot evaluate it and shows #NAME?. The _xlfn prefix is how the file marks functions that arrived in a later version; older Excel displays it because it cannot translate it. Often the cached values show for a moment, especially in Protected View, and then turn into errors once editing is enabled and the sheet recalculates.
How do I find the culprits?
- Press Ctrl+F, open Options and set Look in to Formulas.
- Search for _xlfn to find cells already damaged. In your own copy, search for each newer function name: XLOOKUP, FILTER, LET, LAMBDA, SORT, UNIQUE, TAKE, TEXTAFTER.
- Or press Ctrl+backtick, the key above Tab, to show every formula in the sheet and scan them.
Safe swaps, before and after
| Newer formula | Older replacement |
|---|---|
| =XLOOKUP(A2,$F$2:$F$80,$G$2:$G$80,"Not found") | =IFERROR(INDEX($G$2:$G$80,MATCH(A2,$F$2:$F$80,0)),"Not found") |
| =SUM(FILTER($C$2:$C$500,$A$2:$A$500="Food")) | =SUMIFS($C$2:$C$500,$A$2:$A$500,"Food") |
| =COUNTA(UNIQUE($A$2:$A$500)) | =SUMPRODUCT(($A$2:$A$500<>"")/COUNTIF($A$2:$A$500,$A$2:$A$500&"")) |
| =IFS(C2>5000,"High",C2>1000,"Medium",TRUE,"Low") | =IF(C2>5000,"High",IF(C2>1000,"Medium","Low")) |
The two lookup swaps behave the same: INDEX and MATCH find the matching row and return the value, and IFERROR supplies the fallback. The SUMIFS swap gives the same total as filtering and summing. IFS only matters if your reader is on Excel 2016. The UNIQUE count is the awkward one, and the SUMPRODUCT version is harder to read; if you cannot swap it cleanly, paste values instead.
A worked before and after
Say Food has three rows, ₹450, ₹1,800 and ₹300, and Travel has one at ₹2,200. The FILTER version returns 450 + 1,800 + 300 = ₹2,550 for Food. The SUMIFS version returns the same ₹2,550. If it does not match on your own data, the swap has a typo in a range, so compare the two before you delete the original.
What if a function has no easy swap?
- LET: write the repeated part out in full. The formula gets longer but works everywhere.
- LAMBDA, MAP, SCAN and BYROW: replace with helper columns and fill-down formulas.
- Spilled results: paste them as values in a separate sheet for the reader.
- Anything else: send a PDF or a values-only copy. Select the cells, copy, then Paste Special and Values.
Are there other causes of #NAME?
Yes, and it is worth ruling them out. A typo in a function name, a named range that was deleted, or text in a formula without quotation marks can all produce the same error even on the newest Excel. If it appears on your own machine, fix the typo first. If it appears only on someone else's, suspect the version.
What if my CA needs the file?
Accountants and tax filers sometimes work on older software, or open files in a restricted mode. Ask in advance which format suits them. A CSV file opens in every version and holds values only, so formulas vanish, which is exactly what you want for a hand-off. A PDF is fine for reading but not for editing. If you must send the workbook, send the reader copy with the older formulas or values, and keep the working copy to yourself.
Before you press send
- Search for the newer function names and for _xlfn.
- Swap or paste values for each one you find.
- Check the totals against your original.
- If you can, open the reader copy on an older machine or ask the person which Excel they use.
Rules for sharing tax or financial records change, and your CA may have preferences about format, so ask what they would like to receive.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


