Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Microsoft Excel Spill Error: Causes and FixesMicrosoft Excel’s #SPILL! error means a formula is trying to return multiple results, but Excel cannot place the results in the cells…
- Excel Spill Error: Why It Happens and How to Fix ItTo fix Excel’s #SPILL! error, select the cell showing the error, identify the intended spill range, and remove whatever is blocking that…
- Excel #VALUE! Error: Causes and FixesIf Excel keeps showing #VALUE!, a formula is usually trying to use text, a date, or another incompatible value as a number—or…
- ISBLANK Not Working on a Cell With a Formula?Yes—this is usually expected behavior, not a problem with Excel. ISBLANK returns FALSE when a cell contains a formula, even if that…
- ISBLANK Not Working in Excel? Find the Real CauseISBLANK is usually working as designed: it returns TRUE only when the cell it checks has no contents. A formula that displays…
- IRR Formula Excel #NUM! Error: Causes and FixesIn Excel, =IRR(A2:A5) returns #NUM! when Excel cannot find an internal rate of return for the cash flows using its iterative calculation,…
- INDEX MATCH Not Working? Fix Common Excel Lookup ErrorsIf INDEX MATCH is not working in Excel, start by using an exact-match formula and checking that the lookup and return ranges…
- INDEX MATCH Not Working? Fix Common Lookup ErrorsIf INDEX MATCH works for some values but not others, the usual cause is that Excel sees the lookup value and the…
- IFERROR VLOOKUP Not Working? Common Causes and FixesIFERROR with VLOOKUP usually seems not to work because the formula is malformed, the problem is not an Excel error, or VLOOKUP…
- IMAP Not Working in Outlook? Troubleshoot the CauseIf IMAP is not working in Outlook, first confirm your internet connection and your email provider’s current server settings, then check the…
- IFERROR Not Working in Excel? Find and Fix the CauseIf IFERROR is not working in Excel, first check that the formula is written as =IFERROR(your_formula, value_to_show_if_an_error_occurs) and that the formula inside…
- Hyperlink Not Working in Word Header? Fixes That HelpA hyperlink in a Word header usually works, but Word may require a modifier-click to open it, or the link may point…
- Hyperlink Not Working in Microsoft Word? Causes and FixesIf a hyperlink in Microsoft Word will not open, first try holding Ctrl while clicking it on Windows, or Command while clicking…
- Hyperlink Not Working in Outlook? Fixes That HelpIf a hyperlink is not working in Outlook, first check whether Outlook is waiting for a Ctrl+click, then test the link in…
- Hyperlink Not Working in PowerPoint? Fix the Common CausesIf a hyperlink is not working in PowerPoint, first test it in Slide Show view: in editing view, PowerPoint may require Ctrl+click…
- Hyperlink Not Working in New Outlook? Fixes That HelpIf a hyperlink is not working in new Outlook, first check that it is a real link, then confirm Outlook is allowed…
- Hyperlink Not Working in Outlook 365? Fixes to TryIf a hyperlink is not working in Outlook 365, first test it with Ctrl+click in classic Outlook, then check that Windows has…
- Power Query Divide by Zero Error: How to Fix It QuicklyTo fix a divide-by-zero error in Power Query, check whether the divisor is zero or null before dividing, and return a suitable…
- Hyperlink in Word Not Working? Fixes That Usually HelpIf a hyperlink in Word is not working, first try following it with Ctrl+click on Windows or Command+click on a Mac; Word…
- How to Fix a #REF! Error in Excel Without Losing DataTo remove a #REF! error in Excel, first make a copy of the workbook, then find the formula showing the error and…
- How to Resolve a #REF! Error in ExcelTo resolve a #REF! error in Excel, find the formula containing the broken reference, then undo the deletion that caused it or…
- Remove #DIV/0! Errors From an Excel PivotTableTo remove a #DIV/0! error from an Excel PivotTable, either fix the division formula in its source data and refresh the PivotTable,…
- How to Get Rid of a #REF! Error in ExcelTo get rid of a #REF! error in Excel, edit the affected formula and replace its invalid cell or range reference with…
- Excel #DIV/0! Error: How to Hide It Without Hiding DataTo stop Excel showing a #DIV/0! error, wrap a division formula in IFERROR or check that its denominator is not zero first.…
- Excel #VALUE! Error: Find and Fix the Common CausesTo eliminate Excel’s #VALUE! error, check the cells used by the formula, correct any text or spaces where numbers are expected, and…
- Excel #REF! Error: How to Find and Repair the FormulaTo find a #REF! error in Excel, press Ctrl+F, search for #REF!, and choose Find All; then inspect each result and repair…
- Excel #REF! Error: How to Fix and Prevent Reference ErrorsTo correct a #REF! error in Excel, inspect the formula that shows the error, identify the missing cell, range, or sheet reference,…
- Why Is My VLOOKUP Not Working? Excel FixesVLOOKUP usually fails because the lookup value does not exactly match the first column of its table, the formula uses the wrong…
- HLOOKUP Not Working? Fix Common Microsoft Excel ErrorsIf HLOOKUP is not working in Excel, first check that the value you want to find is in the top row of…
- Hide #DIV/0! Errors in Excel FormulasTo hide a #DIV/0! error in an Excel formula, wrap the calculation in IFERROR: with the numerator in A2 and the denominator…