Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Div 0 Error in Excel AVERAGE: Causes and FixesExcel shows #DIV/0! for an average when the calculation has no numeric values to average, so its count of numbers is zero.…
- Excel #DIV/0! Error: How to Prevent It in Your FormulasTo avoid Excel’s #DIV/0! error, make sure a formula never divides by a blank or zero denominator. For example, with the value…
- DDE Error in Excel: What It Means and How to Fix ItA DDE error in Excel usually means Windows or another program cannot pass a request to Excel through Dynamic Data Exchange, a…
- Date Not Working in Excel? Causes and FixesIf a date is not working in Excel, first check whether the cell contains a real date value or text that only…
- Excel Data Validation Not Working? Fix Common IssuesIf Excel data validation is not working, first select an affected cell and open Data > Data Validation to confirm the rule…
- Data Validation Error in Excel: Causes and FixesA data validation error in Excel means an entry does not meet a rule set for that cell, such as a permitted…
- COUNTIFS Not Working With Dates? Fix the CriteriaYes—COUNTIFS often misses dates because its criteria are written as text, the cells contain text rather than real Excel dates, or the…
- COUNTIF With a Cell Reference Not Working? FixesIf COUNTIF is not using your cell reference, check that the reference is not inside quotation marks: with values in A2:A8 and…
- COUNTIFS Not Working With Multiple Criteria? Fix ItIf COUNTIFS is not working with multiple criteria, check that every criteria range is the same size, that each criterion is paired…
- COUNTIF Not Working for Text? Fix the Common CausesYes—Excel COUNTIF can count text, and it normally ignores letter case. For an exact match, use =COUNTIF(A2:A10,"Apple"); if the result is wrong,…
- COUNTIF Not Working? Fix Common Excel Counting ErrorsIf COUNTIF is not working properly in Excel, first check that its range and criterion refer to the intended cells, then look…
- COUNTIF Not Working With Text? Fix the Common CausesIf COUNTIF is not working with text in Excel, first check that the text in the criteria matches the cell contents and…
- Excel COUNTIF Not Counting Properly? Fix the CauseIf Excel COUNTIF is not counting properly, check the criterion, the cells’ actual contents, and the range first: most mismatches come from…
- COUNTIF Not Working With Dates? Fix Common CausesCOUNTIF date checks usually fail because the cells contain text instead of real Excel dates, the criteria are written incorrectly, or the…
- COUNTIF Does Not Work? Fix Common Excel ProblemsCOUNTIF usually fails because the value in its range does not match the criterion exactly, the criterion is written incorrectly, or the…
- Circular Reference in an Open Workbook: Find and FixA circular reference warning when you open an Excel workbook usually means that one or more formulas depend on their own results,…
- Outlook Clean Up Old Items Not Working? How to Fix ItIf Clean Up Old Items is not working in Outlook, first check that you are using classic Outlook for Windows: the command…
- Why Isn’t a Hyperlink Working in Excel? Common FixesAn Excel hyperlink may seem broken because desktop Excel often requires Ctrl+click to follow it, or because the link’s address, file location,…
- Why Won’t Hyperlinks Work in Excel? Causes and FixesHyperlinks in Excel usually fail because the link points to a moved or mistyped destination, Excel is waiting for a modifier-key click,…
- Why Is Flash Fill Not Working in Excel?Flash Fill usually fails because Excel cannot confidently detect a consistent pattern, the feature is turned off, or you are using a…
- Stellar Fix for Corrupted Excel Files: What to KnowYes. Stellar Repair for Excel is a third-party utility designed to recover data from certain damaged Excel workbooks, but it cannot guarantee…
- Remove a Circular Reference Error in Excel QuicklyTo remove a circular reference in Excel, select Formulas > Error Checking > Circular References, open the listed cell, and edit its…
- Excel Circular Reference Errors: Find and Fix ThemIn Excel, a circular reference occurs when a formula depends on its own result, either directly or through a chain of other…
- Excel Circular Reference: How to Find and Fix ItIn Excel for Microsoft 365 on Windows, go to Formulas > Error Checking > Circular References, then select a listed cell to…
- Microsoft Excel Page Breaks: How to Insert and Fix ThemA page break in Microsoft Excel marks where printed output moves to a new page. In Excel for Microsoft 365 on Windows,…
- Microsoft Excel Formula Not Calculating? Fix ItIf a Microsoft Excel formula is not calculating, first check Formulas > Calculation Options and select Automatic. If that does not fix…
- Microsoft Excel Circular Reference Error: How to Fix ItA Microsoft Excel circular reference error means a formula depends on its own result, either directly or through other cells. Find the…
- Excel Circular Reference Error: How to Find and Fix ItIf Excel keeps showing a circular reference error, find the formula loop and change one reference so the formula no longer depends…
- Excel Not Responding: How to Fix Freezes and HangsIf Excel keeps showing “Not Responding,” first give it a little time if it may be calculating or opening a large file;…
- How to Fix a Corrupted Excel SpreadsheetTo fix a corrupted Excel spreadsheet in Microsoft 365 for Windows, first make a copy of the file, then try Excel’s built-in…