Trace Dependents Type Functions Hushed

  • Thread starter Thread starter Grace
  • Start date Start date
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
 
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..
 
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





.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing functions hushed 3
Trace dependants or Precedents on a protected sheet 1
Trace Dependent - off worksheet page reference 1
trace dependents in named cells in Excel 2007? 3
Trace dependents is inactive 1
Tracing dependents 1
tracing precedents and dependents 3
Trace Dependents? 2

Back
Top