| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel
Tried all the tip ideas and still having trouble getting rid of a circular
reference |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel
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... In article , dusty wrote: Tried all the tip ideas and still having trouble getting rid of a circular reference |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel
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... In article , dusty wrote: Tried all the tip ideas and still having trouble getting rid of a circular reference |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel
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 toolsoptionscalculation...uncheck the automatic..try to click ITErations...and you will be good until the time you finish all your circuiting formula(s).. -- regards, "dusty" wrote: Tried all the tip ideas and still having trouble getting rid of a circular reference |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel
You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Or was this one of those ideas you tried??? dusty wrote: Tried all the tip ideas and still having trouble getting rid of a circular reference -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel
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. On Nov 14, 5:42 pm, dusty wrote: Tried all the tip ideas and still having trouble getting rid of a circular reference |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
