Errors & fixes
What #N/A, #REF! and the rest mean, and how to clear them.
- Excel Spill Error: What It Means and How to Fix ItExcel’s #SPILL! error means a formula is trying to return multiple results, but Excel cannot place all of them in the cells…
- Excel XLOOKUP Spill Error: Causes, Fixes, and ExamplesAn Excel XLOOKUP spill error usually means the formula is returning multiple results but Excel cannot place them in the cells where…
- Set Numbering Value in Word Not Working? How to Fix ItIf Set Numbering Value in Word is not working, right-click the actual list number—not the paragraph text—and choose Set Numbering Value. In…
- Excel #REF! Error: How to Fix Broken Cell ReferencesTo fix an Excel #REF! error, edit the formula that displays it and replace the invalid reference with the correct cell, range,…
- Remove Spill Error in Excel: Causes and FixesTo remove a #SPILL! error in Excel, select the error cell, inspect the outlined spill range, and clear or move anything blocking…
- Excel Spill Error: Causes, Fixes, and Quick ChecksTo resolve an Excel #SPILL! error, select the formula cell, identify what is blocking its intended output range, and remove or move…
- INDEX MATCH #REF! Error: How to Find and Fix the CauseA #REF! error in an Excel INDEX MATCH formula means that part of the formula points to a cell or range Excel…
- Excel #REF! Error: Causes and FixesAn Excel #REF! error means a formula contains a reference to a cell, range, or worksheet that Excel cannot identify. Find the…
- Excel #REF! Error: Causes, Fixes, and PreventionA #REF! error in Excel means a formula contains an invalid cell reference: Excel can no longer find a cell, range, or…
- Excel #REF! Error: Causes and How to Fix ItThe #REF! error in an Excel formula means that the formula contains an invalid cell reference. Find the broken reference, then replace…
- Excel #REF! Error: Fixing Broken Cell References in FormulasA #REF! error in Excel means a formula contains a cell reference that is no longer valid. If it appeared right after…
- VLOOKUP #REF! Error: Why It Happens and How to Fix ItA VLOOKUP #REF! error means the formula contains an invalid cell or range reference. The most common cause is a column number…
- Excel Spill Error: Causes and Ways to Fix ItThe Excel #SPILL! error means a formula is trying to return results into multiple cells, but Excel cannot place one or more…
- VLOOKUP Not Working? Causes and FixesVLOOKUP usually stops working because it cannot find an exact match, the lookup column is not the first column in the selected…
- Why Is VLOOKUP Not Working? Common Causes and FixesVLOOKUP usually fails because its match setting is wrong, the lookup value does not match the data exactly, the lookup column is…
- VLOOKUP Not Working? Causes and FixesIf VLOOKUP is not working, set its final argument to FALSE for an exact match, then check that the lookup value appears…
- How to Prevent #DIV/0! Errors in ExcelTo prevent a #DIV/0! error in Excel, check that the divisor is not zero before dividing. For example, with the numerator in…
- Power Query Replace Value Not Working? Find the FixWhen Power Query’s Replace Values command appears not to work, the cause is usually a mismatch in the value, data type, selected…
- PowerPoint Presenter Mode Not Working? Fixes That HelpIf PowerPoint Presenter View is not working, check that your displays are set to extend, then open the Slide Show tab and…
- Power Query Filter Not Working? Fix Common CausesIf a Power Query filter is not working, first check the filter step in the Power Query Editor, confirm the column’s data…
- Outlook Spam Filter Not Working? Fix Common CausesIf Outlook’s spam filter is not working, first check the Junk Email folder, your safe and blocked sender lists, and any inbox…
- Outlook Spell Check Not Working? Fix the Main CausesIf Outlook spell check is not working, first check whether you are using classic Outlook or the new Outlook, then confirm spelling…
- Outlook Sleep Mode Not Working? Fix Notifications and SyncIf Outlook “sleep mode” is not working, first identify what you mean: Outlook has no single sleep-mode switch. Its mobile app can…
- Outlook Not Working Today? Status Checks and FixesIf Outlook is not working today, the cause could be a Microsoft service disruption or a problem with your device, network, account,…
- Outlook Null Value Error: Causes and FixesAn Outlook null value error usually means that Outlook, an add-in, or a connected service tried to use information that was missing…
- Outlook Signature Hyperlink Not Working? Fixes That HelpIf an Outlook signature hyperlink is not working, first check whether the message is being composed in HTML, then edit the signature…
- Outlook Folder Link Not Working? Causes and FixesIf an Outlook hyperlink to a folder will not open, first check what kind of folder it points to and whether you…
- Outlook Junk Filter Not Working? Causes and SolutionsYes—Outlook’s junk filter can miss spam or send legitimate mail to Junk, but checking the right folder, reviewing blocked and safe senders,…
- Outlook Find Related Messages Not Working? FixesIf Outlook’s Find Related command is missing or returns no messages, first check which Outlook version you’re using: the command is available…
- Outlook Find Related Not Working? Fixes and AlternativesIf Outlook Find Related is missing or returns no messages, first check that you are using classic Outlook for Windows and have…