trace

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...

I recall seeing someone (I don't recall who/where) use a shortcut or option within a lengthy code in VBE to trace the origin of a variable... i.e., find in the previous code where the variable had been declared and defined or set. Can you help me remember or rediscover this?

I am using Excel 2016. I have the following formula in cell A3 =A1+A2. If I select A3 and click Trace Precendents then it highlights A1 and A2. If I select either A1 or A2 and click Trace Dependents I get a message saying "The Trace Dependents command found no formulas that refer to the active...

Hi all I've been maintaining a long-standing Excel performance management template (.xltm) accessed by dozens of users and updating and storing data in multiple MS Access DBs (.accdb) for a while now, but the whole system pre-dates me by some time. As such, I'm not across all the relationships...

In EXCEL 2007 is there a method to trace a cell value in a table to a chart value similar to Trace Precedence or Trace Depenents for table/formula values? Simply put, is there a visual GUI that will tie a table value to its bar or line graphed point? These are simple graphs and charts not pivot...