Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Circular Reference Warning in Excel: Find and Fix ItA circular reference warning in Excel means a formula refers to its own cell, either directly or through a chain of other…
- Circular Reference Error in Excel: Find and Fix ItA circular reference error in Excel means a formula depends on its own result, either directly or through other cells. To find…
- Circular Reference Not Working in Excel? Fix ItA circular reference in Excel will not calculate as expected if iterative calculation is off, the formula does not converge, or a…
- Can You Fix a Corrupted Excel File? Safe Recovery StepsYes—Excel can often repair a corrupted workbook, but recovery is not guaranteed and some content may be lost. On Windows, first make…
- YEAR Formula Not Working? Excel FixesIf Excel’s YEAR formula is not working, first check that its reference contains a real Excel date, not date-looking text, and that…
- Why Won’t Transpose Work in Excel? Causes and FixesTranspose usually fails in Excel because the destination range is blocked, the copied range has an awkward shape, or the method used…
- Why UNIQUE Is Not Working in ExcelExcel’s UNIQUE function usually fails because the installed Excel version does not support it, the formula’s spill range is blocked, or the…
- Excel UNIQUE Not Working? Causes and FixesExcel’s UNIQUE function usually stops working because the installed Excel version does not support it, the formula has an error, or the…
- Why Is the Dollar Sign Not Working in Excel Formulas?The dollar sign in Excel has two common jobs: it can display a number as currency, or it can lock a cell…
- Why Is UNIQUE Not Working in Excel?UNIQUE usually stops working because your Excel version does not support the function, its results cannot spill into nearby cells, or the…
- Why Is the YEAR Function Not Working in Excel? FixesThe YEAR function usually fails because the referenced value is text or an invalid date, or because Excel is displaying the formula…
- Why Is Transpose Not Working in Excel? Fixes to TryTranspose usually fails in Excel because the destination is blocked, the wrong range or paste option is selected, or a dynamic-array formula…
- Excel PV Formula Not Working? Common Causes and FixesThe Excel PV formula usually seems wrong because its interest rate and payment periods do not use the same time unit, its…
- Why Is My TRANSPOSE Formula Not Working in Excel?Your Excel TRANSPOSE formula usually fails because its result cannot fit in the destination, it was entered using the wrong method for…
- Why Is My MATCH Formula Not Working in Microsoft Excel?Most MATCH formulas fail because the match type is wrong, the lookup value differs from the data, or the lookup range is…
- Why Is My SUMPRODUCT Formula Not Working? Checks and FixesA SUMPRODUCT formula usually fails because its ranges do not have matching dimensions, its data contains errors or text where numbers are…
- Excel ROUND Function Not Working? Fixes to TryYour Excel ROUND function usually appears not to work because the value is stored as text, the formula has a syntax or…
- Why Is My IFERROR Formula Not Working in Microsoft Excel?Your IFERROR formula usually appears not to work because Excel is not evaluating the formula you think it is, the error occurs…
- Why Is My IRR Formula Not Working in Excel?Your IRR formula usually is not working because the cash-flow range has no change from negative to positive (or positive to negative),…
- Excel Find Not Working? Causes and Fixes ExplainedExcel’s Find command usually fails because it is searching the wrong sheet or selection, looking in formulas instead of displayed values, or…
- IRR Formula Not Working in Excel? Causes and FixesThe IRR formula usually fails because the cash-flow range is incomplete or contains no valid positive-and-negative combination, the cash flows are not…
- Why Is IRR Not Working in Excel? Causes and Fixes ExplainedIRR in Excel usually fails because the cash-flow range has the wrong signs or data, the cash flows are not evenly spaced,…
- Why Is the LEFT Formula Not Working in Excel?The LEFT formula usually fails because Excel is reading the entry as text, the formula has an invalid character count or separator,…
- COUNTA Not Working in Excel? Causes and FixesCOUNTA often seems not to work because it counts every cell that is not truly empty—including cells with formulas that return an…
- Why Is Find Not Working in Excel? FixesFind in Excel usually appears not to work because the search is limited to the wrong sheet or cell range, is looking…
- Why Is AVERAGE Not Working in Excel?Excel’s AVERAGE function usually appears not to work because the selected range contains numbers stored as text, an error value, or no…
- Why Is AVERAGE Not Working in Excel? Common FixesIf AVERAGE is not working, Excel may not recognize the selected cells as numbers, the formula may point to the wrong range,…
- Why Is a Hyperlink Not Working in Excel?A hyperlink in Excel usually fails because it is being clicked the wrong way, points to a moved or mistyped destination, or…
- VLOOKUP Not Working Until You Click the Cell?If VLOOKUP shows an old or incorrect result until you edit the formula cell, the most common cause is that Excel is…
- Excel WEEKDAY Formula Not Working? Fix Common ErrorsIf Excel’s WEEKDAY formula is giving an error or the wrong day number, first confirm the referenced cell contains a real Excel…