Trace Precedents/Trace Dependents Tools Disabled

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file in which the Trace Predents and Dependetns tools are disabled.
Only this file. If I copy the worksheet to another file, they work fine. I
ran Detect & repair ... no fix. Any idea what causes this? My work around
is I copied the sheets to different file. But I'd like to understand the
root cause. Ideas?

Thanks
 
Hi,

Very unlikely, but: if a chart or graphic object is selected these tools are
disabled. If the cursor is on the formula bar they are also disabled.
Someone could have written a VBA routine to disable them.

In any case - copy the sheet, then delete the original sheet and replace it
with the copied sheet.
 
Back
Top