A simple question: when your worksheet has a circular reference, how do you find it?
P Peter Marshall Dec 13, 2005 #1 A simple question: when your worksheet has a circular reference, how do you find it?
G Guest Dec 13, 2005 #2 Hi Usually Excel gives you the cell reference in the status bar, and puts a blue dot in the offending cell! Andy.
Hi Usually Excel gives you the cell reference in the status bar, and puts a blue dot in the offending cell! Andy.
D Dave Peterson Dec 13, 2005 #3 If you have trouble finding them, maybe Stephen Bullen's utility will help: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip
If you have trouble finding them, maybe Stephen Bullen's utility will help: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip
J JE McGimpsey Dec 13, 2005 #4 Check out the Locate cells that create a circular reference topic in XL Help. The answer involves the "Navigate Circular Reference" box on the Circular Reference toolbar...
Check out the Locate cells that create a circular reference topic in XL Help. The answer involves the "Navigate Circular Reference" box on the Circular Reference toolbar...
