Trace

• Detailed information on each functions calculations.
• Trace is invoked by, instead of recalculating the spreadsheet or using F2 to edit/calc the cell, simply selecting Trace from the BF menu. A dialog box then pops up with information on the calculations the function has performed.
• Provides explanation of any errors, especially #NUM! errors.
• If one or more input variables are incorrectly specified (ie wrong), Trace tells you which variable was at fault, and waht was wrong with it.
• If a function fails during its calculations (quite rare), Trace provides an audit trail to the point where the failure occurred.
• Trace generates quite a lot of detail - sometimes too much and we are looking at ways of organising its output - but where it excels is in the screening of the inputs and the message it gives whene an error is encountered or occurs.