Formulas - trace dependents

[MetLife]

Hi,

I noticed that when I hover over some cells in a particular tab in my workbook, that the trace dependents option is greyed out.

Does this mean there are no dependents? This may be a dumb question, I was just confused because I thought this data was referenced in my spreadsheet.

Thanks,

 

[saboh12617]

Hello,
I read there Redirecting that you can press CTRL+6 to reactivate it. It has nothing to do with the availability of dependents as normally the button is always available.

 

[jkpieterse]

Is the worksheet protected by any chance?

 

[MetLife]

Is the worksheet protected by any chance?

Yes it was protecting. Then I had to hit "ctrl+6" to get it back.

THanks!

 

[MetLife]

Its odd that they remove that option when the sheet is protected.