Try ToolsFormula AuditingEvaluate Formula, as I suggested in my previous
posting

--
Kind regards,

Niek Otten

"David Smith" wrote in message
...

"Ron Rosenfeld" wrote in message
...
On Mon, 21 Nov 2005 08:48:23 -0500, "David Smith"
wrote:

"Ron Rosenfeld" wrote in message
...
On Sun, 20 Nov 2005 12:17:28 -0500, "David Smith"
wrote:

Hello,

Is there a way (addin utilities or otherwise) to cause the formula in a
cell
to display the values for the component references making up the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S



I don't know if this will be helpful, but you could also set up a Watch
Window
and Watch the contents of the references.
--ron

Hi Ron,
I am not to famiiar with the visual basic editor. I can view the watch
window but how do I do what you suggest?

Thanks....

David S


This is an Excel feature, no VBA required.

View/Toolbars and select the Watch Window toolbar. You can then set a
Watch
for various cells.

This is different from the Watch window in VBA.


--ron

Hi Ron,

Tried that but it does not give me anything more than the value in the
total cell and its formula. I am interested in seeing the individual
values of the component parts of a formula as described in my original
post. So I can do a quick audit of the formula based on an assumption
sheet or known values.

Thank you.....

David S