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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
