Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Workbook Link Broken? How to Fix ItIf an Excel workbook link is broken, first identify whether you mean an external-workbook reference in a formula or a clickable hyperlink:…
- Excel Won’t Filter by Dates? Fix the Data and SortIf Excel won’t filter by dates, the most common cause is that some or all of the entries are stored as text…
- Excel Won’t Sort Dates Correctly? Fix Date SortingExcel usually sorts dates incorrectly because some entries are stored as text, the column contains mixed date formats, or only part of…
- Excel Web Formula Not Working? Causes and Fixes That WorkIn Excel for the web, a formula usually fails because it is stored as text, has a syntax or reference error, is…
- Excel VLOOKUP Not Working? Fix Formula ErrorsIf VLOOKUP is not returning the result you expect, check the lookup range and use an exact match: with the value to…
- Excel VLOOKUP Number Format Issue: How to Fix ItA VLOOKUP number-format problem is usually a mismatch between the stored values, not the way they look on screen: Excel treats a…
- Excel VLOOKUP Invalid Cell Reference Error: Fix ItIn Excel, a VLOOKUP invalid cell reference error is usually #REF!. Check that the column number in the formula is no larger…
- Excel VLOOKUP Number Format: Fix Text and Numeric ValuesVLOOKUP returns a value, not the source cell’s number format. To change how the result looks, format the cell containing the formula;…
- Excel VLOOKUP Error Messages: How to Create OneTo show a helpful message when VLOOKUP cannot find a match, wrap it in IFNA: =IFNA(VLOOKUP(E2,$A$2:$C$100,3,FALSE),"Product not found"). Use IFERROR instead if…
- Excel VLOOKUP Examples With IFERROR and Error HandlingTo handle a VLOOKUP value that is not found, wrap an exact-match VLOOKUP in IFNA and provide a useful fallback, such as…
- Excel VLOOKUP Copy Formula Down Not Working? FixesIf VLOOKUP works in the first row but returns wrong results or errors after you copy it down, the lookup range is…
- Excel TRIM Formula Not Working? Fix Hidden SpacesIf Excel’s TRIM formula seems not to work, the text may contain a nonbreaking space, a tab, or another character that TRIM…
- Excel TRUE/FALSE Formula Not Working? FixesIf an Excel TRUE/FALSE formula is not working, first check that it starts with =, that its cell references and comparison are…
- Excel TRANSLATE Formula Not Working? Fixes That HelpIf Excel’s TRANSLATE formula is not working, first confirm you are using Microsoft 365 or Excel for the web, then check the…
- Excel Text Box Formula Not Working? Fix ItIf an Excel text box formula is not working, select the text box’s outer border, enter a cell reference in the Formula…
- Excel Table Not Showing Filter Options? Fix ItIf an Excel table is not showing filter options, select a cell in the table and check Table Design > Table Style…
- Excel Table Not Copying Formulas to New Rows? Fix ItIf an Excel table is not copying formulas to new rows, first check that calculated-column formula filling is enabled: in Excel for…
- Excel Table Filter Not Updating? Fix It Step by StepIf an Excel table filter is not updating, first choose Data > Reapply to refresh the current filter and sort, then check…
- Excel SUMIF: Avoid Errors and Fix Common ProblemsExcel’s SUMIF can return an error when a cell it needs to add contains an error value; to total matching rows while…
- Excel SUMIF Spill Error: Why It Happens and How to Fix ItA SUMIF spill error (#SPILL!) means Excel is trying to return multiple results but cannot put them into the cells it needs.…
- Excel Spill Error When Creating a Table: Causes and FixesExcel shows #SPILL! when a dynamic-array formula tries to return results inside an Excel Table, because spilled arrays cannot expand within table…
- Excel Spell Number Formula Not Working? Fixes That HelpIf an Excel spell-number formula such as =SpellNumber(A2) is not working, the likely reason is that Excel has no built-in SpellNumber function:…
- Excel Sort Dates Wrong? Fix the Order and Find the CauseWhen Excel sorts dates into the wrong order, the usual cause is that some entries are stored as text rather than as…
- Excel Sort Dates: Why You See A to Z and How to Fix ItIf Excel offers only A to Z and Z to A when you try to sort dates, it may be treating the…
- Why Some Excel Dates Are Left Aligned and How to Fix ThemIn Excel, dates that are left aligned are often text rather than real date values: Excel normally aligns text left and numbers,…
- Excel Showing Text Instead of Formula? How to Fix ItIf Excel displays a formula in the cell instead of its result, first check whether Show Formulas is turned on; if it…
- Excel Showing Formula Instead of Result? Fix ItIf Excel is showing a formula instead of its result, first turn off Show Formulas from the Formulas tab; on Windows, Ctrl+`…
- Excel Circular Reference Warning: Find and Fix ItExcel’s circular reference warning means a formula depends on its own result, either directly or through other cells. To find the loop…
- Excel Filter Shortcut Not Working? Causes and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. If nothing happens, select a cell inside…
- Excel Share Not Working? Fix Sharing and CoauthoringIf Excel’s Share button is missing, greyed out, or not giving someone access, first save the workbook to OneDrive or SharePoint, sign…