Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Circular warning not showing up
I used to get an error message at the bottom of my excel window that read
'Circular' and would list a cell that was involved in the circular. Now, in the place where that error used to show up, there is 'Ready Calculate' and no error, even though there is a circular reference. Is there a way to make the error show up? |
#2
|
|||
|
|||
You likely have Tools / Options / Iterations checked, which will allow circs
to calculate through a number of iterations. An example of this would be when some forms price contracts they may have a particular overhead that is a % of the sell price, yet is itself a part of that sell price. Just untick it, but be sure you were meant to. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Arran" wrote in message ... I used to get an error message at the bottom of my excel window that read 'Circular' and would list a cell that was involved in the circular. Now, in the place where that error used to show up, there is 'Ready Calculate' and no error, even though there is a circular reference. Is there a way to make the error show up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highest Value / Circular Reference Help | Excel Discussion (Misc queries) | |||
Highest Value / Circular Reference Help | Excel Worksheet Functions | |||
formula in cell not showing result | Excel Worksheet Functions | |||
Help solve a Circular Reference | Excel Worksheet Functions | |||
Bar showing value for missing data | Charts and Charting in Excel |