Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am getting a very annoying circular error msg but the cell reference is not
showing up at the bottom of the screen. I have tried both enabling and disabling the Iteration function but it does not make a difference. I do see "table" references in the bottom for just a second like "table 3" which then become "Ready" - is that a clue to help me find the infringing cell? Many thanks! |
#2
![]() |
|||
|
|||
![]()
Maybe Stephen Bullen's utility will help find that circular reference.
http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Remote Todd wrote: I am getting a very annoying circular error msg but the cell reference is not showing up at the bottom of the screen. I have tried both enabling and disabling the Iteration function but it does not make a difference. I do see "table" references in the bottom for just a second like "table 3" which then become "Ready" - is that a clue to help me find the infringing cell? Many thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Cell reference manipulation | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |