Error Check

Location on ribbon: Tab DVD Addin → Group Formula → Menu Calculate Menu

Command ID: btnFormulaErrorChecking

What it does

This command turns Excel's background formula error checking on or off — the little green triangles in the top-left corner of a cell and their warning markers. You choose whether the change applies to the current selection or to the whole Excel application.

In construction paperwork a great many of these warnings are false alarms: a formula that "omits adjacent cells", item codes stored as text, a package total whose formula differs from its neighbours. Silencing them on the right range keeps the sheet clean for printing and for screenshots sent to the client; switching them back on is one click when you need to audit again.

How to use

1. If you intend to work on a range, select it first.
2. Go to tab DVD Addin → group Formula → menu Calculate Menu → click Error Check.
3. The Formula error checking window opens with two blocks:
   • Scope: Selected range (default) or Entire Excel application.
   • The checkbox Enable error checking (ticked = on, unticked = off).
4. Pick the scope, then tick or untick the box according to what you want.
5. Click Apply. With the Selected range scope, the change hits whatever is selected at the moment you click.
6. The window stays open: select another range and Apply again, or click Close when finished.

Example

A quantity summary sheet has item codes like AF.11220 in column A entered as text, so the whole column shows the green "Number stored as text" triangle. Select A6:A180, open Error Check, leave the scope on Selected range, untick "Enable error checking" and click Apply — the warnings disappear and the printout is clean.

When handing the file to a colleague for review, reopen the command, switch to Entire Excel application, tick the box and Apply to restore full checking.

Notes

• The command only toggles the warning flags; it does not edit formulas and it does not hide genuine errors such as #REF!, #DIV/0! or #N/A.
• The Entire Excel application scope is an Excel setting on your machine: it affects every workbook and survives closing the file — remember to switch it back if you only meant to silence things temporarily.
• The Selected range scope uses the selection at the moment you press Apply, not the one that existed when the window opened.
• The window is modeless, so you can select a different range and click Apply again.
• The checkbox keeps whatever state you last set, so glance at it before each Apply to avoid toggling the wrong way.

Related

• Dependents — check a cell's downstream impact before deciding which warnings are false alarms.
• Rounding Func — the same style of window for bulk-editing formulas in a selection.
• Lock Ref — fix $ reference styles on formulas flagged as "inconsistent with neighbours".