Can't turn off trace dependents

art79

New Member
Joined
Dec 8, 2018
Messages
1
Hi everyone - trace dependents seems to be stuck turned on.

I've tried the normal going into formulas and clicking remove arrows, but then as soon as I scroll to another cell with dependents, it comes back. When I select everything in the sheet and click "remove arrows" the message I get is "the remove arrows command found no tracer arrows to remove."

I also tried going into advanced ->display options for this workbook ->for objects, show and selected "nothing (hide objects)". This doesn't work either. Strangely, when I open settings back up, it's always set back to "all."

Everything I've found online is about being unable to turn trace precedents on, but nothing about it being stuck on. Has anyone had this issue / know a fix? Thanks in advance.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,109,127
Messages
5,526,989
Members
409,733
Latest member
revender17

This Week's Hot Topics

Top