Checking accuracy of multiple formulas

[ricw]

Can anyone tell me a fast way to check the accuracy of multiple formulas
accross multiple worksheets? I have a workbook with about 50 to 60
worksheets in it and I need to check all the formulas for accuracy.
Thanks in advance! Rick

 

[Frank Kabel]

Hi
what do you exactly want to check?. The procedure depends on the type
of your formulas

 

[ricw]

Hi Frank,
Thanks for getting back to me on this. Actually what I would like to d
is to step thru each argument in each formula and have the argument
take me to where the information is coming from so I can check th
accuracy. I have a workbook with 218 worksheets and 1 of the worksheet
has over 3000 formulas in it.

Is there a macro that I could use to step thru each formula a littl
faster? Anything you could tell me is greatly appreciated.

It seems like this is going to take forever to check all the formulas.

Thank you,
Ric

 

[Frank Kabel]

Hi
have a look at the toolbar 'Track dependencies' (not sure about this
trasnlation though)

 

[ricw]

Thank you for looking into this, but what you suggested really doesn'
work for me. I would like to be able to maybe start a macro and have i
step thru the formula taking me to the different sheets where it get
data from so I can look to see if it is the correct cell and if it i
the correct information. I can see that I have a huge undertaking
There are thousands of different formulas in this workbook. Again
thank you for your time.
Ric