Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Print Area Not Saving? Fix and Keep ItIf an Excel print area is not saving, set it on the correct worksheet, save the workbook as an Excel file such…
- Excel Print Area Not Clearing? Fix It in Microsoft 365If an Excel print area will not clear, select the affected worksheet and choose Page Layout > Print Area > Clear Print…
- Excel Print Area Cut Off? Fix Margins, Scaling, and Pages in ExcelIf an Excel print area is cut off, first check the worksheet in File > Print to see what is missing, then…
- Excel Power Query Not Updating? Fix Refresh ProblemsIf Excel Power Query is not updating, select Data > Refresh All in Excel for Microsoft 365 on Windows, then check whether…
- Why Won’t PowerPoint Add Slide Numbers? Common FixesPowerPoint usually will not show slide numbers because the number option was not applied to every slide, the slide’s layout lacks a…
- PowerPoint Embed Video Not Playing? How to Fix ItIf an embedded video will not play in PowerPoint, first check that the clip is in a compatible format—Microsoft recommends MP4 with…
- Excel Pasted Formula Not Calculating? Fix the CauseIf a formula you pasted into Excel is not calculating, first check Formulas > Calculation Options > Automatic, then check whether the…
- Excel Only Showing Formula? Fix Calculation and DisplayIf Excel is showing a formula instead of its result, first turn off Formulas > Show Formulas; on Windows, you can also…
- Excel Not Responding When Saving? How to Fix ItIf Excel says Not Responding while saving, give it a few minutes before closing it: a large workbook, recalculation, an add-in, or…
- Excel Arrow Keys Not Working? Fix Scroll Lock and MoreIf Excel’s arrow keys are not moving the active cell, first turn off Scroll Lock: press the Scroll Lock (ScrLk) key, or…
- Excel Not Responding? Fix Hangs, Freezes, and CrashesIf Excel says Not Responding, first give it a minute without clicking repeatedly; it may be busy calculating, loading a file, or…
- Excel Not Responding Every Few Seconds? Fix the PausesIf Excel stops responding for a few seconds at regular intervals, first save a copy of the workbook if you can, then…
- Excel Circular Reference Example and How to Fix ItAn Excel circular reference occurs when a formula refers to its own cell, either directly or through other formulas. For example, if…
- Remove Errors in Excel PivotTables: Fix or Hide ThemTo remove errors from an Excel PivotTable, first correct the error in its source data, then refresh the PivotTable. If you only…
- Google Sheets Keeps Changing Date Format? Here’s WhyGoogle Sheets usually changes a date because it automatically recognizes typed or pasted text as a date, or because the cell’s number…
- XLOOKUP Formula Not Working? Fix Common ErrorsIf your XLOOKUP formula is not working, first check that your Excel version supports XLOOKUP, that the lookup and return ranges are…
- Why XLOOKUP Is Not Working in Excel: Causes and FixesXLOOKUP usually fails because Excel does not support the function, the lookup and return ranges do not line up, or the lookup…
- Why Won’t Data Validation Work in Excel? Common FixesExcel data validation usually seems not to work because the rule is missing or applied to the wrong cells, the dropdown is…
- Why Is Password Protection Not Working in Excel?Password protection often seems broken because Excel has several different protections: encrypting a file, locking a worksheet, and protecting workbook structure. First…
- Why COUNTIF Isn’t Working in Excel and How to Fix ItCOUNTIF usually appears not to work because its criteria do not match the cells exactly, the data contains hidden spaces or inconsistent…
- Excel Formula Not Working? Common Causes & FixesAn Excel formula usually fails because Excel is treating it as text, the formula contains a syntax or reference error, the input…
- Why Is My LEFT Formula Not Working in Excel?Most LEFT formulas fail because Excel is reading the entry as text, the formula syntax or argument separator is wrong, or the…
- Why Are Excel Keyboard Shortcuts Not Working on Windows?Excel keyboard shortcuts usually stop working because Excel does not have the expected focus, a laptop key changes the keystroke, or another…
- Where to Find an Excel File After a Crash on WindowsAfter Excel crashes on Windows, reopen Excel and check the Document Recovery pane first; open the newest recovered version and save it…
- Excel VLOOKUP Spill Error: Causes and FixesA VLOOKUP spill error usually means Excel cannot place all the results a formula is trying to return into the cells beside…
- VLOOKUP in Excel: Fix #N/A ErrorsVLOOKUP in Excel returns #N/A when it cannot find the lookup value in the first column of its search range. With the…
- VLOOKUP Spill Error in Excel: Causes and FixesA VLOOKUP formula shows #SPILL! when Excel is trying to return an array of results but cannot place all of them in…
- Excel IF Function #VALUE! Error: Causes and How to FixA #VALUE! error in an Excel IF formula means that part of the calculation Excel needs to perform has an incompatible value,…
- Excel VLOOKUP #VALUE! Error: Causes, Checks, and FixesIn Excel for Microsoft 365 on Windows, VLOOKUP most commonly returns #VALUE! when its third argument, col_index_num, is less than 1 or…
- Excel UNIQUE and FILTER #CALC! Error: Causes and FixesA #CALC! error in an Excel formula that combines UNIQUE and FILTER most often means FILTER found no rows to return. With…