Formula and function debugging
Broken formulas, nested function errors, lookup failures, and calculations that quietly return wrong numbers.
Excel Troubleshooting
Excel Troubleshooting: Fix Errors, Slow Files, and Crashes
Learn what each Excel error means and how to fix it yourself. If the workbook still will not behave, our Excel experts diagnose and repair it on a copy of your file.
Excel troubleshooting means finding out why a workbook shows errors, calculates the wrong answer, runs slowly, or will not open, then fixing the cause rather than the symptom. Start with the error value in the cell: it names the problem type. If there is no error but the number is wrong, check calculation mode and number formats, then step through the formula with Evaluate Formula. This guide covers the common fixes. If you are stuck, Excel Access Expert diagnoses and repairs the workbook for you.
Start here: match your Excel problem to a fix
| What you see | First thing to try |
|---|---|
| An error value in a cell (#REF!, #N/A, #VALUE!) | Look up the error in the table below; the type points to the cause. |
| A formula shows the wrong number but no error | Set calculation to Automatic, check for numbers stored as text, then use Evaluate Formula. |
| The formula text shows instead of the result | Change the cell format from Text to General, re-enter the formula, and check that Show Formulas is off. |
| Excel is slow, freezes, or runs out of resources | Look for volatile functions, oversized ranges, and circular references (see the slow workbook section). |
| The file will not open or says it is corrupt | Use File > Open > Open and Repair on a copy of the file. |
| A macro stopped working | Check Trust Center settings, whether the file is blocked, and missing references (see the macro section). |
Excel error messages: what they mean and how to fix them
Each error value points to a specific type of problem. Use this table to find the cause before you change anything.
| Error | What it means | Most common cause | How to fix it |
|---|---|---|---|
| #REF! | A cell the formula points to no longer exists | A row, column, or sheet was deleted, a range was pasted over, or a linked workbook is missing | Press Ctrl + Z straight after the deletion. Otherwise re-point the formula to the right cells, or check Data > Edit Links for a missing source file. |
| #VALUE! | A value is the wrong type for the formula | Text where a number is expected, hidden spaces, or ranges of different sizes | Clean the data with TRIM or VALUE, then step through the formula with Formulas > Evaluate Formula. |
| #DIV/0! | The formula divides by zero or an empty cell | A blank or zero denominator | Guard the division: =IF(B2=0,"",A2/B2) |
| #NAME? | Excel does not recognize a name in the formula | A misspelled function, an undefined named range, text missing quotation marks, or a function your Excel version lacks (XLOOKUP needs Excel 2021 or later, or Microsoft 365) | Check the spelling, define the missing name in Name Manager, or use a function your version supports. |
| #N/A | A lookup cannot find what it is looking for | Extra spaces, a text versus number mismatch, or a value that is truly missing from the lookup range | Compare the two values with TRIM and check their data types. Use exact match. Wrap in IFNA only once you know a missing match is expected. |
| #NUM! | A number is invalid for the calculation | An impossible argument, such as the square root of a negative number, or an iterative function such as IRR or RATE that cannot converge | Check the arguments and give IRR or RATE a better starting guess. |
| #NULL! | Two ranges do not intersect | A space typed where a comma or colon was intended | Use a colon for a range (A1:A10) and a comma between arguments. |
| #SPILL! | A dynamic array formula has no room to spill | Cells in the spill range are not empty, or the formula sits inside an Excel table | Clear or move whatever blocks the spill range, or move the formula outside the table. |
| ##### | The cell cannot display the value | The column is too narrow, or a date or time result is negative | Widen the column and check the date or time calculation. |
| Circular reference warning | A formula refers to its own cell, directly or through other cells | A total that includes the cell it is written in | Use Formulas > Error Checking > Circular References to jump to the cell, then remove the self-reference. |
Excel formula gives the wrong result but no error
These are the hardest problems because nothing flags them. They are also the most expensive, since people make decisions from the wrong number. Check these first:
Calculation is set to Manual
Under Formulas > Calculation Options, choose Automatic. Press F9 to force a recalculation.
Numbers are stored as text
A green triangle in the corner of the cell is the clue. Convert the values with Text to Columns or by multiplying by 1, and fix the cell format.
Hidden or filtered rows are included
SUM counts hidden rows. Use SUBTOTAL or AGGREGATE when you want filtered results only.
Approximate match in a lookup
A VLOOKUP with the last argument omitted or TRUE uses approximate match and can return a wrong row. Use FALSE (or 0) for an exact match.
References that move when copied
A missing dollar sign ($) lets a reference shift. Lock the parts that must stay fixed.
How to troubleshoot any Excel formula in five steps
Step 1: Read the error or symptom
Note the exact error value, message, or behavior. The type of error narrows the cause: #REF! is a missing reference, #N/A is a failed lookup, #VALUE! is a wrong data type.
Step 2: Check calculation mode and cell formats
Confirm Formulas > Calculation Options is set to Automatic and that numbers are not stored as text. Many wrong results come from these two settings.
Step 3: Trace the formula
Use Formulas > Evaluate Formula to step through the calculation, and Trace Precedents to see which cells feed it.
Step 4: Test the pieces
Select part of a formula in the formula bar and press F9 to see what that part returns, then press Esc to cancel so you do not overwrite the formula.
Step 5: Fix on a copy and recheck
Make the change on a copy of the workbook, then confirm the totals still agree with a known good figure before replacing the original.
Why is my Excel workbook slow, freezing, or crashing?
A slow workbook is almost always doing too much work every time a cell changes. Look for these causes, roughly in order of how often they appear:
Volatile functions
OFFSET, INDIRECT, TODAY, NOW, and RAND recalculate on every change, along with everything that depends on them.
Oversized used range
Press Ctrl + End. If the cursor lands far below your real data, formatting or stray entries are bloating the file.
Whole-column references in heavy formulas
Formulas such as SUMPRODUCT over entire columns force Excel to process over a million rows.
Excess conditional formatting and duplicated rules
Copying and pasting cells over time can create thousands of overlapping rules.
External links and add-in conflicts
Broken links slow opening, and a faulty add-in can cause crashes. Start Excel in Safe Mode (hold Ctrl while launching) to test.
If the workbook keeps freezing when several people use it, or the data keeps growing, the cause is the tool rather than the formulas. See Excel-to-database solutions and Excel vs Access.
Excel file will not open or says it is corrupt
Work on a copy and try these in order:
Choose File > Open, select the file, click the arrow beside Open, and choose Open and Repair. Try Repair, then Extract Data.
Right-click the file, open Properties, and select Unblock if you see that option. Files from email or the web can be blocked.
Start Excel in Safe Mode by holding Ctrl while launching it, then open the file to rule out add-ins.
Check OneDrive or SharePoint version history for an earlier good version, and File > Info > Manage Workbook > Recover Unsaved Workbooks for unsaved work.
If it still will not open, stop trying new tools on the original and send us a copy.
Our Excel file repair service covers files that will not open at all.
Excel macro or VBA stopped working
The file is blocked or macros are disabled
Microsoft blocks macros by default in files that come from the internet or email. Unblock the file in Properties and review your Trust Center macro settings.
Missing references
In the VBA editor, open Tools > References and look for an entry marked MISSING. A missing library breaks code that has nothing wrong with it.
32-bit and 64-bit differences
Older code that calls Windows functions needs PtrSafe declarations to run in 64-bit Office.
Hard-coded paths, sheet names, or the active sheet
Code that works on one PC fails on another when paths differ or when it assumes the wrong sheet is active.
When to stop troubleshooting and call an Excel expert
Fixing it yourself is sensible for a single error. Get help when any of these is true:
The workbook drives payroll, invoicing, month-end, or reporting that others rely on.
The numbers are wrong and you cannot find where the error starts.
The file is corrupt, and the only copy is the one that will not open.
A macro written by someone who has left stopped working.
The same problems keep returning, which usually points to structure or tool choice.
Our team works on a copy of your file, explains the root cause in writing, and returns a corrected workbook you can run. For ongoing work, such as automation or rebuilding a fragile workbook, see our Microsoft Excel consultant services.
Our Excel troubleshooting and repair services
Diagnose, fix, and harden your Microsoft Excel workbooks.
Crash and corrupted file repair
Workbooks that will not open, crash on load, or show corruption warnings. We recover what the file allows and rebuild the rest.
Performance tuning
Slow, bloated workbooks cleaned up by trimming ranges, restructuring formulas, and removing needless recalculation.
Macro and VBA troubleshooting
Runtime errors, compile errors, missing references, and macros that broke after an Office update.
Data integrity and validation
Inconsistent data cleaned up and validation rules added so bad entries stop at the door.
Integration troubleshooting
Broken links, add-ins, and connections to Access, SQL Server, Power BI, and other data sources.
How our Excel troubleshooting process works
Step 1: Share a copy of the file
Send the workbook through secure sharing or a redacted sample. We work on a copy and never on your only original.
Step 2: Diagnosis and root cause
We trace every error to its source and document what we find, usually within the first hour of looking.
Step 3: Fix, test, and validate
We repair the workbook and check the affected formulas, macros, and connections against known figures.
Step 4: Delivery and prevention notes
You get the corrected file and a written summary of what was wrong and how to avoid it.
Remote Excel troubleshooting for US, Canadian, and UK businesses
Excel Access Expert provides remote Microsoft Excel troubleshooting to businesses across the United States, Canada, and the United Kingdom. No on-site visit is needed. Teams in finance, logistics, manufacturing, sales, HR, and healthcare administration send us workbooks such as financial models, inventory trackers, billing logs, and payroll calculators. If a file holds sensitive data, we can start from a redacted copy.
Why hire us for Excel troubleshooting?
You get the cause explained and the problem fixed, not a pile of workarounds.
Root-cause diagnosis
We trace each error to its source instead of patching the symptom, then explain it in plain English.
Fast response
We typically reply within 1 to 2 hours, and many urgent problems are resolved the same day.
VBA and automation repair
We debug and repair macros and add error handling so failures are visible.
Excel and Access specialists
When the problem is that the data outgrew Excel, we tell you and can move it to Access or SQL Server.
Excel troubleshooting FAQs
FAQ
Frequently Asked Questions
Find answers to common questions about our services
Start with what Excel is showing you. If a cell has an error value such as #REF! or #N/A, the error type tells you the likely cause. If a formula gives a wrong number with no error, check that calculation is set to Automatic and that numbers are not stored as text. Then step through the formula with Formulas > Evaluate Formula. For slow or crashing files, look for volatile functions, oversized used ranges, and add-in conflicts. Always work on a copy of the file.
#REF! means a referenced cell no longer exists. #VALUE! means a value is the wrong type for the formula. #DIV/0! means the formula divides by zero or an empty cell. #NAME? means Excel does not recognize a name or function. #N/A means a lookup could not find its value. #NUM! means a number is invalid for the calculation. #NULL! means two ranges do not intersect. #SPILL! means a dynamic array result is blocked by other cells. A cell full of hash signs (#####) means the column is too narrow or a date or time is negative.
There are three usual causes. Calculation may be set to Manual (Formulas > Calculation Options > Automatic, or press F9 to recalculate). The cell may be formatted as Text, so Excel treats the formula as plain text; change the format to General and re-enter the formula. Or Show Formulas may be switched on (Ctrl + ` toggles it).
Usually the workbook is doing too much work on every change: volatile functions such as OFFSET, INDIRECT, TODAY, NOW, and RAND, whole-column references inside heavy formulas, a used range far larger than the real data, excessive conditional formatting, or many external links. Saving as .xlsb can shrink very large files. If the slowness is structural, the data may have outgrown Excel.
In Excel choose File > Open, select the file, click the arrow beside the Open button, and choose Open and Repair. Try Repair first, then Extract Data if Repair fails. If the file still will not open, check whether it is blocked (right-click the file, open Properties, and select Unblock), start Excel in Safe Mode by holding Ctrl while launching it, and look for earlier versions in OneDrive or SharePoint version history. Always make a copy before you try recovery.
Excel stopped because a calculation exceeded the memory or processing available to it. Common causes are circular references, very heavy array or lookup formulas over large ranges, and 32-bit Excel running into its memory limit. Check Formulas > Error Checking > Circular References, simplify or narrow the heaviest formulas, and consider 64-bit Excel for large models.
Yes. We diagnose and repair workbooks that crash, freeze, or fail to open. We work on a copy of your file, recover as much data as the file allows, and rebuild the structure so the workbook works reliably again.
Often, but not always. We use Excel's built-in recovery, direct inspection of the file contents, and rebuild work to retrieve data from damaged .xlsx and .xlsm files. Recovery depends on how much of the file is intact, and we tell you what we can and cannot recover before you commit to further work.
Yes. We debug runtime and compile errors, repair macros that broke after an Office update or a move to a new PC, fix missing references and 32-bit versus 64-bit problems, and add error handling so failures are visible instead of silent.
We typically reply within 1 to 2 hours, and many urgent issues are resolved the same day. Timing depends on the size of the file and the cause of the problem, and we give you an estimate before work starts.
We work on a copy, use secure file sharing, and sign an NDA if you ask. If the data is sensitive, we can start from a redacted sample until you are comfortable sharing the full workbook.
Yes. We handle issues in Excel for the web and Google Sheets, and we help with converting or migrating between spreadsheet platforms when that is the better fix.
Yes. Along with the fix we explain what went wrong and can add data validation, error handling, and structural improvements so the same problem is less likely to return. If a workbook keeps failing because many people edit it or the data is too large, we will say so and outline the move to Access or SQL Server.
Get expert Excel troubleshooting help today
Share a copy of your Excel file for a free estimate. We diagnose the issue and tell you what it will take, with no obligation.
1
15-min audit
→
2
Fixed-scope quote
→
3
Deliver outcome
15+Years Experience
FixedScope Quotes
2011Established
Prefer to talk? Call us at +1 385 386 3860