Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Tracking formula errors in Excel
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel consultants - Tracking formula errors in Excel
Resolved · Low Priority · Version Standard
Reply Thu 7 Dec 2006, 19:14Delegate Morag said...
Morag has attended:
Excel Intermediate course
Tracking formula errors in Excel
I there an easy way to find errors in formulas between different excel workbooks?
For upcoming training course dates see: Pricing & availability
RE: tracking formula errors
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.
Tracking Formula Errors - Formula Auditing Toolbar
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
|