#NUM! ERRORS

Hello dlbibb​,

It sounds like Excel is tripping over recalculation in your large workbook rather than the formulas themselves. The #NUM! error usually means Excel hit an invalid numeric result (like dividing by zero, square root of a negative, or log of zero), but in your case the fact that pressing Enter clears it suggests cached values aren’t refreshing properly.

A few things you can try:

• Force a full recalculation: Press Ctrl + Alt + F9 to recalc every formula in the workbook. This often clears up random #NUM! errors without editing cells one by one.
• Check calculation settings: Go to Formulas > Calculation Options and make sure it’s set to Automatic.
• Iterative calculations: If you’re using circular references, check File > Options > Formulas and adjust the maximum iterations/precision. Too tight a limit can trigger #NUM!.
• Audit formulas: Use Formulas > Error Checking to see if any formulas are producing invalid math.
• Clear hidden corruption: Save the workbook under a new name. Sometimes this resets stale cached values.

If you want the spreadsheet to handle these errors automatically, you can wrap formulas with IFERROR. For example:

=IFERROR(YourFormulaHere, "")

This will return a blank instead of #NUM!. You could also replace the "" with a default value like 0 or "Error" depending on what makes sense for your sheet.

Since your workaround is just re‑entering the cell, the most effective fix is usually the Ctrl + Alt + F9 full recalculation. That way you don’t have to chase down each error manually, and adding IFERROR gives you a safety net if any invalid math slips through.

When #NUM! errors “randomly” appear but disappear as soon as you re-enter the formula, it’s usually not a bad formula—it’s a calculation or precision issue.

You can try to fix the issue with this steps…

Step 1: Save the file.
Step 2: Press Ctrl+Alt+Shift+F9 to force a full recalculation.
Step 3: If the error persists, check for circular references.
Step 4: If there are circular references, either fix them or enable iterative calculation (but be cautious because iterative calculation can lead to incorrect results if not used properly).
Step 5: If no circular references, try to isolate the problem by removing sheets or parts of the data.

If the problem is fixed by the full recalculation, then it might have been a corrupted dependency tree. If it happens again, then we might need to look deeper.

However, note that the file is 1,017 KB (about 1MB). That's not extremely large, but it's moderate. It might have a lot of formulas.

Another idea: the file might be using linked cells or external references that are sometimes unavailable? But that usually gives a #REF! error.

Alternatively, the problem might be with the Excel installation? Try repairing Office.

Steps:

• Go to Control Panel -> Programs -> Programs and Features -> Microsoft Office -> Change -> Repair.

But that is a last resort.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.