Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Not Enough Memory Error: Causes and Fixes ExplainedIf Excel says there is not enough memory to complete an action, first save your work if possible, close other applications, and…
- Excel Error Message When Opening a File: Causes and FixesAn Excel error message when opening a file usually means Excel cannot read the file as presented, the workbook is damaged, or…
- Excel Error Messages: What They Mean and How to Fix ThemExcel error messages are codes such as #DIV/0!, #VALUE!, and #REF! that show a formula could not return its intended result. Read…
- Excel Error Handling: Fix and Prevent Formula ErrorsExcel error handling means finding why a formula returns an error and deciding how to respond. In Microsoft 365 for Windows, use…
- Excel Merged Cells Must Be the Same Size? Fix the ErrorYes—when Excel says “To do this, all the merged cells need to be the same size,” it usually means the range you…
- Excel Fixed Objects Will Move Error: How to FixThe Excel message ‘Fixed objects will move’ usually means a worksheet object—such as a chart, shape, picture, or note—is interfering with an…
- Excel File Format Is Not Valid: Causes and How to Fix ItIf Excel says a file format or file extension is not valid, first check that the file finished downloading and that its…
- Excel Copy and Paste Not Same Size? Fix the ErrorExcel displays the copy-and-paste size error when the copied cells and the selected destination do not have a compatible shape. The quickest…
- Excel Error Codes: What They Mean and How to Fix ThemExcel error codes are messages that show why a formula or data operation could not return its expected result. The familiar examples…
- Excel Error: Convert an Entire Column to Real NumbersTo fix Excel’s “number stored as text” error across a column, select the affected cells and choose the warning icon, then Convert…
- Excel Error 0x80004005: Causes, Checks, and Common FixesExcel error 0x80004005 is a generic Windows failure code, not a diagnosis of one specific Excel problem. The right fix depends on…
- Excel Error 0x80070194: OneDrive Fixes and CausesExcel error 0x80070194 usually means Windows could not reach the cloud-file provider for a workbook stored in OneDrive; the message commonly says,…
- Excel Error Checking: Find and Fix Formula ErrorsIn Excel for Microsoft 365 on Windows, select the cell with the problem and choose Formulas > Formula Auditing > Error Checking…
- Excel Error 0x426-0x0: What It Means and How to Fix ItExcel error 0x426-0x0 is usually an Office desktop startup problem, often involving the Microsoft Office Click-to-Run service that manages Microsoft 365 and…
- Excel Error: Why You Can’t Change Part of an ArrayThe Excel message “You can’t change part of an array” means the cell you are trying to edit belongs to an array…
- Excel Can’t Push Objects Off Sheet Error: How to FixExcel’s “Can’t push objects off sheet” error usually means an object—such as a picture, chart, shape, or note—would be pushed beyond the…
- Excel All Cells Must Be the Same Size Error ExplainedThe Excel message “To do this, all the merged cells need to be the same size” usually means the selected range contains…
- Excel Error Bars for Each Point: Set Custom ValuesTo give each point in an Excel chart a different error bar, select the chart, choose Chart Design > Add Chart Element…
- Excel Error 0xc0000142: Causes, Fixes, and Next StepsExcel error 0xc0000142 means Windows could not initialize a component Excel needs while starting the program. Close and reopen Excel, then try…
- Error Loading Add-Ins in Excel: Causes, Checks, and FixesIf Excel says “Error loading add-ins,” first identify the add-in type, then disable it in Excel and restart: go to File >…
- Ctrl+L Excel Shortcut: Create a Table and Fix IssuesIn Excel for Microsoft 365 on Windows, Ctrl+L opens the Create Table dialog for turning a selected data range into an Excel…
- Excel Dollar Sign Shortcut: Fix Cell References in FormulasIn Excel for Microsoft 365 on Windows, press F4 while editing a formula and a cell reference is selected to add or…
- Circular Reference Error in Excel: How to Find It FastTo find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking > Circular References, then click…
- Check Circular References in Excel: Find and Fix ThemTo check for a circular reference in Excel for Microsoft 365 on Windows, open the Formulas tab, select Error Checking, then point…
- Circular Reference in Excel: How to Find and Fix ItTo fix a circular reference in Excel, open Formulas > Error Checking > Circular References, select a listed cell, and edit its…
- Excel Data Analysis Not Working? Troubleshooting and FixesIf Excel’s Data Analysis command is missing or will not run, enable the Analysis ToolPak: in Windows Excel, choose File > Options…
- Excel CSV Import Problems? Fix Dates, Delimiters & MoreFor most Excel CSV import problems, avoid opening the file by double-clicking it. In Excel for Microsoft 365 on Windows, choose Data…
- Page Breaks in Excel Won’t Go Away? How to Fix ThemIf page-break lines in Excel won’t go away, switch to View > Normal to leave Page Break Preview, or hide the indicators…
- Page Break in Excel Not Working? Fix the Common CausesIf a page break in Excel is not working, first switch to View > Page Break Preview and check whether scaling or…
- Conditional Formatting in Excel Not Working?If conditional formatting in Excel is not working, first open Home > Conditional Formatting > Manage Rules and check that the rule…