Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Showing Text Instead of Formula? How to Fix ItIf Excel displays a formula in the cell instead of its result, first check whether Show Formulas is turned on; if it…
- Excel Showing Formula Instead of Result? Fix ItIf Excel is showing a formula instead of its result, first turn off Show Formulas from the Formulas tab; on Windows, Ctrl+`…
- Excel Circular Reference Warning: Find and Fix ItExcel’s circular reference warning means a formula depends on its own result, either directly or through other cells. To find the loop…
- Excel Filter Shortcut Not Working? Causes and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off. If nothing happens, select a cell inside…
- Excel Share Not Working? Fix Sharing and CoauthoringIf Excel’s Share button is missing, greyed out, or not giving someone access, first save the workbook to OneDrive or SharePoint, sign…
- Excel Share Workbook Not Working? Fix Sharing IssuesIf Excel’s sharing is not working, save the workbook to OneDrive or SharePoint, make sure you are signed in, and grant the…
- Excel Share Button Not Working? Practical Fixes to TryIf Excel’s Share button is missing, disabled, or fails to send a link, first make sure the workbook is saved to OneDrive…
- Excel Runtime Error 9: Subscript Out of Range?Excel VBA runtime error 9, “Subscript out of range,” means code tried to access an item that does not exist at the…
- Excel Save Failed Error: Causes, Recovery, and FixesAn Excel save failed error usually means Excel could not write the workbook to its current location; it does not necessarily mean…
- Excel Row Autofit Not Working? Fix Height ProblemsIf Excel row AutoFit is not working, select the affected row or cells and choose Home > Format > AutoFit Row Height.…
- Excel Returns Formula Instead of Value? Fix ItIf Excel displays a formula such as =A2+B2 in the cell instead of its result, first turn off Formulas > Formula Auditing…
- Excel Repair Now Error: Causes and Safe Fixes“Excel repair now error” is not one specific Microsoft Excel error code; it usually describes a prompt or failure while Excel tries…
- Excel Pull-Down Formula Not Working? Fix Common CausesIf an Excel formula will not pull down, select the cell containing it and drag the small square at its lower-right corner…
- Excel Power Query Taking Long to Refresh? Fix the CauseIf Excel Power Query is taking a long time to refresh, first identify whether the delay is at the data source, in…
- Excel Power Query Formula Firewall Error: Causes and FixesThe Excel Power Query Formula.Firewall error usually means a query is combining data sources or referencing another query in a way Power…
- Excel Power Query Data Format Error: Causes and FixesAn Excel Power Query DataFormat.Error usually means a value does not match the data type or format Power Query is trying to…
- Excel Power Query Close and Load Not Working?If Power Query’s Close & Load appears to do nothing, first check whether the query is set to create a connection only…
- Excel PivotTable Average #DIV/0! Error: Causes and FixesAn Excel PivotTable showing #DIV/0! for an Average usually has an error in its source data or in a calculated field; the…
- Excel Number in Scientific Notation: How to Fix ItTo stop Excel from displaying a value in scientific notation, widen the column or select the cells and choose Home > Number…
- Excel Multiply Formula Not Working? Fix Common CausesIf an Excel multiplication formula is not working, first check that it uses the asterisk (*) between valid cell references, then confirm…
- Excel Median Formula Not Working? How to Fix ItIf Excel’s median formula is not working, check that the range contains actual numbers and that the formula points to the right…
- Excel Math Formula Not Working? Causes and Fixes GuideIf an Excel math formula is not working, first check that the cell contains a formula beginning with =, the inputs are…
- Excel Lookup Formula Not Working? Find and Fix the CauseIf an Excel lookup formula is not working, first check that the lookup value and lookup range contain matching data, then confirm…
- Excel Links Broken? Fix External References and LinksUsually, yes: broken Excel links can often be repaired by reconnecting the workbook to its source file or correcting the link address.…
- Excel Keyboard Shortcuts Not Working? Fixes That HelpIf Excel keyboard shortcuts stop working, first click a worksheet cell, exit cell-edit or dialog mode, confirm you are using Ctrl on…
- Excel INDEX MATCH #N/A Error? Common Causes and SolutionsAn #N/A error in an INDEX MATCH formula usually means MATCH cannot find the lookup value in its search range. Check that…
- Excel INDEX MATCH #REF! Error: Causes and Quick FixesAn Excel INDEX MATCH formula returns #REF! when INDEX is asked for a row, column, or reference area that does not exist,…
- Excel INDEX MATCH IFERROR: Handle Missing ResultsTo show a useful result when an INDEX MATCH lookup fails, wrap the lookup in IFERROR, such as =IFERROR(INDEX($B$2:$B$6,MATCH(E2,$A$2:$A$6,0)),"Not found"). Use IFNA…
- Excel IF VLOOKUP Is Not an Error: Formula ExamplesTo show a VLOOKUP result when it works and a message when it errors, use IF with ISERROR. If the lookup value…
- Excel Broken Link: How to Find and Fix ItTo fix a broken link in Excel, first identify whether it is an external workbook link, a broken formula reference, or a…