Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Outlook Email Not Working Today? Check These FixesIf Outlook email is not working today, check Microsoft’s service-health page first, then test the same account in Outlook on the web…
- Outlook Code Not Working? Fix Sign-In CodesIf an Outlook sign-in verification code is missing or rejected, check that you requested it for the right Microsoft account, look in…
- Outlook Dark Mode Not Working? Fixes for Every VersionIf Outlook dark mode is not working, first check that dark mode is enabled in the version of Outlook you are actually…
- Outlook Clean Up Conversation Not Working? Fix ItIf Outlook Clean Up Conversation is missing, unavailable, or leaves messages behind, first check that you are using classic Outlook for Windows…
- Outlook Clean Up Folder Not Working? Fixes That HelpIf Outlook’s Clean Up Folder command is not working, first confirm you are using classic Outlook for Windows and that the folder…
- Outlook Advanced Find Not Working? Fix Search IssuesIf Outlook Advanced Find is not working, first confirm you are using classic Outlook for Windows: the legacy Advanced Find dialog is…
- Outlook Best Match Not Working? Fix Search ResultsIf Outlook Best Match is not working, first check the search scope and try the same query in All results; Best Match…
- OneNote Find Tags Not Working? Common Causes and FixesIf OneNote’s Find Tags feature is not showing the notes you expect, first check that you are using the desktop OneNote app,…
- Outlook /restore Not Working? Fix the Window StateOutlook’s /restore switch is a startup option for classic Outlook for Windows: it asks Outlook to restore its previous window size and…
- Outlook 365 Not Working Today? Check Status and FixesOutlook 365 may be affected by a Microsoft service incident, but I can’t verify live outage conditions from here. Check Microsoft’s service…
- Excel #NUM! Error: Causes, Fixes, and ExamplesExcel’s #NUM! error means a formula cannot produce a valid numeric result, often because an input or function argument is outside an…
- Office 365 Code Not Working? Fix the Common CausesIf an Office 365 code is not working, first identify what kind of code it is: a product key used to redeem…
- Excel IRR #NUM! Error: Causes and FixesIn Excel, IRR returns #NUM! when it cannot find a rate that makes a set of periodic cash flows balance to a…
- Excel Regression P-Value: Fixing the #NUM! ErrorIn Excel, a regression p-value showing #NUM! usually means the test cannot be evaluated with the statistic or degrees of freedom supplied;…
- Excel IRR #NUM! Error: Causes and Practical FixesAn Excel IRR formula returns #NUM! when it cannot find a rate that makes the cash flows’ net present value zero using…
- XLOOKUP Name Error: Causes, Checks, and Fixes in ExcelIf XLOOKUP returns #NAME?, Excel usually does not recognize something in the formula: the function name may be misspelled, your Excel version…
- Null Error in Excel: Causes and FixesIn Excel, the #NULL! error usually means a formula asks for the intersection of two cell ranges that do not overlap. Check…
- Name Error in Excel: What It Means and How to Fix ItThe name error in an Excel formula is #NAME?. It means Excel cannot identify text in the formula as a valid function,…
- Name Error in VLOOKUP: Causes and FixesIn Excel, a VLOOKUP name error is usually #NAME?: Excel cannot recognize the function name or another name used in the formula.…
- Excel #NAME? Error in IF: Causes, Checks, and FixesIn Excel, #NAME? means the formula contains text Excel cannot recognize as a valid function, defined name, or other supported name. In…
- #N/A in Excel: What It Means and How to Fix the Error#N/A in Excel means that a formula or lookup cannot find a required value; it is an error value, not a zero…
- INDEX MATCH #N/A Error: Causes and FixesIn Excel, an INDEX MATCH formula that returns #N/A usually means MATCH cannot find the lookup value in the range it was…
- VLOOKUP #N/A Error: Causes and FixesVLOOKUP returns #N/A when it cannot find the lookup value in the first column of the search range. To fix it, set…
- XLOOKUP #N/A Error: Causes and FixesAn #N/A error in XLOOKUP usually means Excel could not find the lookup value in the lookup range, or that the matched…
- VLOOKUP Not Working? Common Excel Causes and FixesVLOOKUP usually fails because the lookup value and the first column of the search range do not match exactly, the formula uses…
- Hyperlink Not Working in Word? Fixes to TryIf a hyperlink in Word is not working, first try Ctrl+clicking it on Windows; Word often requires that action to open a…
- SUMIF Not Working? Fix Excel Criteria, Ranges, and ResultsIf SUMIF is not working, check that the criteria really matches the cells in your criteria range and that your sum range…
- Excel HYPERLINK Formula #VALUE! Error: Causes and FixesIn Microsoft Excel for Microsoft 365, a #VALUE! error from HYPERLINK usually means Excel cannot interpret the link target or an input…
- Excel Spill Error: What It Means and How to Fix It QuicklyIn Microsoft Excel for Microsoft 365, a #SPILL! error means a formula is trying to return multiple results, but Excel cannot place…
- Microsoft Outlook Not Working Today? Check Status & FixesMicrosoft Outlook may be down today, but I can’t verify live service status from here; check Microsoft’s service-health page and test Outlook…