alternate for Trace precedent

[zen]

I have to enter various figures of work load volume and hourly rates in
various worksheets, at the end I have to run the macro to calculate the
billing amount. The cell which gives me the billing amount is named & I don’t
see any formula written there, can I just see the value in formula bar?
Problem is that the one who developed this file had left & secondly our
nature of business is changing, we just want to see how billing amount is
worked out. Any help will be appreciated.

 

[Sheeloo]

Not sure what you are looking for...

In any cell enter (in the same row, as most likely it will point to a range)
=Billing_Amount
assuming Billing_Amount is the name given to 'billing amount'

 

[Shane Devenshire]

If the value in the cell changes but you don't have formulas in the cells,
only the values, then in suggests that there are macros doing the
calculations.

Press Alt+F11, and in the Project window for your file (top left side),
start by opening any Module folders associated with your file name. If you
don't find anything or there is no Module folder, double-click each of the
sheet names in the Project window and the thisWorksheet object and note if
there is any VBA code.

 

[Shane Devenshire]

Hi,

I forgot to ask - you mention Trace Precedents in your title but you don't
address it in the body of the post - how does this come into play in your
question.

 

[Ashish Mathur]

Hi,

If the formula is not visible, then another possibility could be that the
formula has been hidden by Format cell > Protection > Hidden and then the
sheet has been protected. If this is indeed the case, then you will need
the password to unprotect and then uncheck the Hidden box

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[zen]

Trace precedent was the first thing I tried to use, but it didn't work. So I
was looking for alternatives.