View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default alternate for Trace precedent

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" wrote in message
...
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
dont
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.