MS Excel 2000 / Troubleshooting
 

I've heard of a tool that lets you troubleshoot an equation (entry) even if
Excel has accepted it. It supposedly walks you through the equation and asks
you "go" "no-go" type questions, one step at a time.

Sound familiar to anyone?

Thanks

MS Excel 2000 / Troubleshooting
 

Russ,

In Excel 2003, this capability exists as a part of formula auditing. I
would assume that it also was in Excel 2000. Select the cell containing the
formula of interest, then click Tools Formula Auditing Evaluate Formula.
The tool shows the formula with the innermost part of it underlined.
Clicking the Evaluate button causes Excel to evalute just the underlined
part; it then displays the formula with the evaluated portion replaced by
its result. You can continue stepping through the evaluation in a similar
manner.


-- David

"Russ" wrote in message
...
I've heard of a tool that lets you troubleshoot an equation (entry) even
if
Excel has accepted it. It supposedly walks you through the equation and
asks
you "go" "no-go" type questions, one step at a time.

Sound familiar to anyone?

Thanks

MS Excel 2000 / Troubleshooting
 

David--that feature is new to XL 2003. It's not in XL 2000, though you are
able to audit formulas' dependencies and precedents.

As to the tool the OP is referring to, I am not sure what it would be.
--
Brevity is the soul of wit.


"David Benson" wrote:

Russ,

In Excel 2003, this capability exists as a part of formula auditing. I
would assume that it also was in Excel 2000. Select the cell containing the
formula of interest, then click Tools Formula Auditing Evaluate Formula.
The tool shows the formula with the innermost part of it underlined.
Clicking the Evaluate button causes Excel to evalute just the underlined
part; it then displays the formula with the evaluated portion replaced by
its result. You can continue stepping through the evaluation in a similar
manner.


-- David

"Russ" wrote in message
...
I've heard of a tool that lets you troubleshoot an equation (entry) even
if
Excel has accepted it. It supposedly walks you through the equation and
asks
you "go" "no-go" type questions, one step at a time.

Sound familiar to anyone?

Thanks