Trace dependents not finding relationships which are there

wikurbia

New Member
Joined
May 24, 2008
Messages
6
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 cell" which is clearly untrue. Neither the sheet nor the woorkbook are protected. I can't find any threads which have this problem with such a simple formula. Any suggestions?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
I can't replicate this.

When I select A1, it draws an arrow between A1 and A3, as expected. Same with A2 / A3.

Are you sure you actually selected cell A1 or A2 ?
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top