Trace Dependents Type Functions Hushed

G

Grace

On Jan 7th at 8:33 PM I posted a question as follows (but
received no help yet and fear it will be lost in antiquity
so let me post it again):

I received an EXCEL file from someone else and, when I
open it, most of the functions on the auditing toolbar
(trace dependents, etc) are all hushed for every cell. I
thought that, maybe, the workbook or sheet was protected
but it is not. What else could be prevenbting my access
to these features?

Thanks
 
P

Peo Sjoblom

Tools>options>view and make sure the Objects have show all checked.
If that doesn't help copy the sheet(s) to a new workbook..
 
G

Grace

Ah, excellent! That did it.

Thx.
-----Original Message-----
Tools>options>view and make sure the Objects have show all checked.
If that doesn't help copy the sheet(s) to a new workbook..

--

Regards,

Peo Sjoblom





.
 
Top