Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Since you started a new thread, with a non-meaningful subject line, and
with absolutely no description of what the circular reference refers to
(e.g., what the formula is, what any referred-to cells contain), or what
"tip ideas" you've tried, it's really rather difficult to even know
where to start...
 
Since you've posted a new thread, with a non-meaningful subject line,
with no actual description of your problem (e.g., what the cell with the
circ reference contains, and what any referred-to cells contain) nor
what "tip ideas" you're referring to, it's rather difficult to know
where to start.

Please provide some more information...
 
i'm just guessing...maybe you are trying to get rid of the alarming "circular
reference" pop-up while doing your formulation...try to go to
tools>options>calculation...uncheck the automatic..try to click
ITErations...and you will be good until the time you finish all your
circuiting formula(s)..
 
Go to the circular cell, press Ctrl+[ and that will show you the
previous level of dependent cells. Keep pressing this key combination
until an area is highlighted in which this cell is once again
included.

Alternately, use Trace Precedents repeatedly (under Tools->Formula
Auditing) to achieve the same effect.
 
Back
Top