excel consultants - Tracking formula errors in Excel

There is a built-in error checking system in excel.

Right click on the toolbars, and select FORMULA AUDITING.

Thuis toolbar will give you the tools to trace which cells are involved in the formula.

I suggest looking in the help section of Excel to familiarise yourself with the many aspects of formula checking. Type in "formula error" in the help search, and this will give you a good overview.

The quickest way to trace errors in Excel is by using the Trace Error button on the Formula Auditing toolbar. To do this:

Open the Formula Auditing toolbar

Click the Trace Error button (This is the yellow shape with an exclamation mark on it)

The error traces all the cells in the formula

A dotted line joins the formula cell to an small worksheet symbol indicating cell(s) on the other workbook/worksheet used in the formula.

Double Click the black dot that joins the dotted line to the worksheet symbol.

A Go To dialog box appears.

Click the required cell address

Click OK

NB The destination workbook needs to also be open for this to work