Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel FILTER Function Errors: How to Diagnose and Fix ThemMost Excel FILTER errors come from a criteria range that does not match the data range, no rows meeting the criteria, or…
- Excel FILTER Spill Error: Causes and FixesAn Excel FILTER spill error usually means the formula’s results cannot fit in the cells where Excel wants to display them. Clear…
- Excel FILTER #CALC! Error: Why It Happens and How to FixIn Excel, FILTER most often returns #CALC! because no rows meet its criteria and the optional [if_empty] argument was omitted. Add a…
- Excel Formula Not Working? Fix Common CausesIf an Excel formula is not working, first check whether Excel is showing the formula as text, using manual calculation, or returning…
- Excel File Too Large Because of Blank Cells? Fix ItYes—an Excel workbook can become unusually large when cells that look blank contain formatting, spaces, formulas, or other stored information. To check,…
- Excel F2 Show Formula Not Working? Fixes That HelpF2 does not turn on a worksheet-wide formula display in Excel: it puts the selected cell into edit mode. To show formulas…
- Excel External Links Error: Causes and FixesAn Excel external links error usually means a workbook cannot find, access, or safely update another workbook referenced by a formula. In…
- Excel File Error Repair Online: What Works SafelyYes, you can use an online service to try to repair a damaged Excel file, but it is not a guaranteed fix.…
- Excel Can’t Save Here Error: Causes, Fixes, and ChecksThe Excel message “You can’t save here” usually means Excel cannot write the workbook to the selected location, or the file is…
- Excel Cannot Group Dates? Fix the PivotTable ErrorIn Excel for Microsoft 365 on Windows, the PivotTable message “Cannot group that selection” usually means the date field contains a blank,…
- Excel Error Bars in Cells: What You Can Do InsteadNo: Excel does not have a native feature that places statistical error bars inside an individual worksheet cell. Error bars are chart…
- Excel Equal Formula Not Working? Common FixesIf an Excel equality formula is not working, first check that it is entered as a formula and that both cells contain…
- Excel AutoFilter Not Working? How to Fix ItIf Excel AutoFilter is not working, check that the filter covers the entire data range, that the header row is recognized, and…
- Excel Save Error: Causes, Fixes, and File RecoveryIf Excel says it encountered an error during save, keep the workbook open and try saving a new copy to a different…
- Excel Formula Not Working? Fix Common Entry ProblemsIf Excel will not accept or calculate a formula, check that the entry begins with an equals sign, the cell is not…
- Excel Empty Array Error: Causes, Fixes, and ExamplesThe Excel empty array error is usually #CALC! with the message “Empty Array.” It means a dynamic array formula—most often FILTER—found no…
- Excel Dragging Formula Not Working? How to Fix ItIf Excel will not drag a formula, check that the fill handle is enabled, then drag the small square at the selected…
- Excel Drag Down Formula Not Updating? Fix Common CausesIf an Excel formula does not update when you drag it down, first check that Excel is set to calculate automatically, that…
- Excel Does Not Sort Dates Correctly? How to Fix ItWhen Excel does not sort dates correctly, the usual cause is that some entries are stored as text instead of real date…
- Excel DAYS Formula Not Working? Fix Dates and ErrorsIf the end date is in B2 and the start date is in A2, enter =DAYS(B2,A2); the end date must come first.…
- Excel Dates as Text: Display, Convert, and Fix ThemIn Excel, a date can be displayed as text without changing its underlying date value: apply a date number format, or use…
- Excel Dates Sorting A-Z: Why It Happens and How to FixExcel sorts real dates A to Z in chronological order, from oldest to newest. If the dates look out of order, the…
- Are Excel Dates Stored as Text? How to Check and FixExcel dates are usually stored as numbers, not as text: a date is a serial value that Excel displays using a date…
- Excel Dates as Text: How to Convert and Fix ThemIf Excel dates are stored as text, convert them with Data > Text to Columns or a formula such as DATEVALUE; changing…
- Excel Date Cell Shows as Number? Fix the Serial ValueIf an Excel date cell shows a number, the value is usually a date serial displayed with the General or Number format.…
- Excel Data Validation Stop Error: What It MeansExcel’s Data Validation Stop error alert blocks an invalid value entered directly into a validated cell and offers the user a chance…
- Excel Data Validation Rule Error: Causes and FixesAn Excel data validation rule error usually means the entered value does not meet the cell’s rule, or the rule itself has…
- Excel Data Validation List Not Showing? Fix ItIf an Excel data-validation list is not showing, select the cell and check Data > Data Validation > Settings: Allow must be…
- Excel Data Validation List Not Working? Fixes That HelpIf an Excel data validation list is not working, first select the affected cell and go to Data > Data Validation >…
- Excel Data Validation List Too Short? Fix the Common LimitsIf an Excel data-validation list seems too short, first check whether the list is merely showing a few choices at a time…