Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Power Query Error Checking: 5 Ways to Find ErrorsTo check for errors in Excel Power Query, open the query in Power Query Editor and use View > Column quality or…
- Error 032659 Excel to Table in ArcGIS Pro: What to CheckIf “Error 032659” appears while converting an Excel file to a table, the number alone does not identify a dependable, universal cause;…
- Disk Is Full Excel Save Error: How to Fix ItIf Excel says the disk is full when you try to save, first preserve your open workbook: use File > Save As…
- Dates Not Showing as Dates in Excel? Fix the FormatIf dates are not showing as dates in Excel, first check whether the cells contain real date values or text: select a…
- Data Validation Error Alert in Excel: How It WorksIn Excel for Microsoft 365 on Windows, a data validation error alert is the message shown when someone enters a value that…
- COUNTIF Spill Error in Excel: Causes and FixesA COUNTIF formula usually returns one result, but it can show a #SPILL! error when its criteria argument contains multiple values and…
- COUNTIF Formula in Excel Not Working? Fixes That HelpIf COUNTIF in Excel is returning zero, an error, or a count that looks wrong, check the range and criterion first, then…
- COUNTIF Excel Error Handling: Fixes and WorkaroundsCOUNTIF has no built-in error-handling argument, so wrap it in IFERROR when you want to replace an error result: =IFERROR(COUNTIF(A2:A100,C1),0). This returns…
- Copied Formula Not Working in Excel? Fix ItIf a copied formula is not working in Excel, first check whether the reference changed as intended, the cell is formatted as…
- Conditional Formatting Excel Error Values: How to FlagTo highlight Excel error values, select the cells, go to Home > Conditional Formatting > New Rule > Format only cells that…
- Conditional Formatting in Excel Not Working? Common FixesIf conditional formatting in Excel is not working, first select an affected cell and open Home > Conditional Formatting > Manage Rules…
- Excel Cannot Save or Export XML Data? Fix the ErrorIf Excel says it cannot save or export XML data, first check whether you are saving the workbook or exporting mapped data:…
- Can’t Sort Dates in Excel? Fix Text Dates and Sort OrderIf Excel will not sort dates chronologically, the most common cause is that some or all of the entries are stored as…
- Excel Calculations Not Working? Fix the Common CausesIf calculations in Excel are not working, first check Formulas > Calculation Options > Automatic, then confirm the formula is entered as…
- Excel FILTER #CALC! Error: Why It Happens and How to Fix ItIn Excel for Microsoft 365, FILTER usually shows #CALC! when its criteria find no matching rows and the optional [if_empty] argument is…
- Bloomberg Export to Excel Not Working? Troubleshooting GuideIf Bloomberg will not export to Excel, first identify whether the failure is in a Terminal export or in the Bloomberg Excel…
- Bold Formula Not Working in Excel? How to Fix ItExcel formulas do not make text bold by themselves: a formula calculates a value, while bold is cell formatting. To bold a…
- Bing Chat Excel Formula Not Working? Fixes That HelpIf a formula from Bing Chat is not working in Excel, check that it begins with an equals sign, refers to the…
- Array Function Not Working in Excel? Fixes That WorkIf an array function is not working in Excel, first check whether your Excel version supports it, whether the formula has room…
- Array Formula Excel Not Working? Common FixesIf an Excel array formula is not working, first check whether it needs to spill into empty cells or be entered as…
- Excel Not Allowing to Group Rows? Fix the Common CausesYes, Excel can group rows, but the command may be unavailable or appear not to work if the sheet is protected, the…
- Excel Flash Fill Not Working? Common Causes and FixesIf Flash Fill is not working in Excel, enter one or two examples beside your source data, select the first blank result…
- Excel No Print Area Set? What It Means and How to Fix It“No print area set” in Excel usually means the worksheet has no saved range restricting what can print; it is not an…
- Excel Named Ranges Not Showing Up? Find and Fix ThemIf Excel named ranges are not showing up, first open Formulas > Name Manager (or press Ctrl+F3 on Windows) to check whether…
- Excel Merged Cells Not Wrapping Text? Fix the LayoutIf text in an Excel merged cell is not wrapping, select the merged cell and choose Home > Wrap Text, then increase…
- Excel Merge Duplicate Cells: What It Does and How to FixExcel does not have a command that safely merges duplicate cell contents into one cell: Home > Merge & Center merges cell…
- Excel Merge Empty Cells: What Happens and How to Fix ItYes. In Excel, select the empty cells you want to combine, then choose Home > Merge & Center and the merge option…
- Excel Merge Cells Grayed Out? Causes and How to Fix ItIf Excel’s Merge & Center button is grayed out, check whether you are editing a cell, selecting separate ranges, working inside an…
- Excel Link Not Responding? Fix Hyperlinks and LinksIf an Excel link is not responding, first check whether it is a clickable hyperlink or an external-workbook link: for a hyperlink…
- Excel Keeps Saying Not Responding? Fix the CauseIf Excel says Not Responding, first stop clicking and give it a few minutes: a large calculation, refresh, or file operation can…