Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Data Validation Error Message: How to Set It UpAn Excel data validation error message is the alert shown when someone enters a value that violates a cell’s validation rule. In…
- Excel Data Validation Error Alert Not Working?If an Excel data validation error alert is not appearing, open Data > Data Validation > Data Validation, select the Error Alert…
- Excel Data File Too Large? Fix Size and Find the CauseIf an Excel data file is too large, first work out whether the problem is opening, saving, sharing, or fitting the data…
- Excel Custom Number Format Not Working? FixesIf an Excel custom number format is not working, first confirm the selected cells contain numbers or dates rather than text, then…
- Excel COUNTIFS #VALUE! Error: Causes, Checks, and FixesIn Excel, COUNTIFS returns #VALUE! most often because its criteria ranges are different sizes; make every range cover the same rows and…
- Excel COUNTIF Spill Error? Causes and FixesExcel’s COUNTIF usually returns one count when its criteria argument is a single value. In Microsoft 365, it can return several counts—and…
- Excel Copy Formula Drag Down Not Working? Try These FixesIf dragging a formula down in Excel does nothing, first check that the fill handle is enabled: go to File > Options…
- Excel Copy and Paste Formula Not Working? Quick FixesIf an Excel formula will not copy and paste correctly, first check whether the copied cell contains a formula, then use Home…
- Excel Conditional Formatting Formula for Error CellsTo highlight cells that contain Excel errors, create a conditional-formatting rule using =ISERROR(A2). This example assumes the range starts at A2; select…
- Excel Cell Shows Formula Instead of Result? How to Fix ItIf an Excel cell shows a formula instead of its result, first check whether Formulas > Formula Auditing > Show Formulas is…
- Excel Cell Showing Date Instead of Number? Fix the FormatIf an Excel cell shows a date instead of a number, select it and change its number format to General or Number:…
- Excel Cell Showing Formula Instead of Value? Fix ItIf an Excel cell shows a formula instead of its result, first turn off Formulas > Formula Auditing > Show Formulas; on…
- Excel Cell Showing 0 Instead of Result? Fix ItIf an Excel cell shows 0 instead of the result you expect, first select it and check the formula bar: this reveals…
- Excel Cell Formula Not Working? Fix the Common CausesIf an Excel formula is not working, first check that the cell is formatted as General, the formula begins with an equals…
- Excel Can’t Save File Error: Causes, Checks, and FixesIf Excel says it can’t save a file, first protect your changes: choose File > Save As > Browse and try saving…
- Excel Cannot Change Part of Array Error: How to FixExcel shows “You can’t change part of an array” when you try to edit or delete only some cells governed by one…
- Excel Autofit Row Height Not Working? Causes and FixesIf Excel AutoFit row height is not working, select the affected rows and choose Home > Format > AutoFit Row Height. If…
- Excel Autofit Not Working? Fix Width and Height IssuesIf Excel AutoFit is not working, select the affected columns or rows and choose Home > Format > AutoFit Column Width or…
- Excel Auto Formula Not Working? Causes and FixesIf an Excel formula is not calculating, select Formulas > Calculation Options > Automatic, then check that the cell is not formatted…
- Excel Auto Calculate Not Working? Fixes and ChecksIf Excel is not automatically updating formula results, set calculation to Automatic: go to Formulas > Calculation Options > Automatic. If that…
- Excel Add M to Number Format: Display Millions or SuffixYes. In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number > Custom, and enter 0"m" to append…
- Errors Were Detected While Saving Excel: How to Fix ItTo fix Excel’s “Errors were detected while saving” message, first preserve your work: use File > Save As to save a separate…
- Excel Error While Saving: Causes and FixesIf Excel reports that an error was detected while saving, first preserve the original workbook: use File > Save As to save…
- Excel Error While Saving: Causes, Fixes, and RecoveryIf Excel reports that errors were detected while saving, first choose to continue only if Excel offers a repair, then save the…
- Power Query Error Trapping in Excel ExplainedIn Excel Power Query, trap a row-level error with M’s try expression, then decide whether to replace it, keep its details, or…
- Power Query Excel Error 5: What It Means and How to Fix ItThere is no single Microsoft Excel Power Query message called simply “Error 5.” The number may be a value that caused a…
- Error Saving Excel File? Common Causes and Reliable FixesIf Excel says it cannot save, choose File > Save As > Browse and save a new copy with a short name…
- Power Query Error Function in Excel: What Error 5 MeansIf you mean Excel’s ERROR.TYPE result 5, it identifies the #NAME? error. Power Query does not assign errors that same numbered code:…
- Power Query Error Handling in Excel: 5 Practical FixesIn Excel Power Query, inspect the error to find its cause, then choose Transform > Replace Errors to substitute a suitable value…
- Excel Error Bars for Power Query Data: A Practical GuidePower Query does not add error bars: it imports and reshapes data, while Excel charts display error bars. In Microsoft 365 for…