Ciruclar Reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Marshall - 13 Dec 2005 13:56 GMT

A simple question: when your worksheet has a circular reference, how do you
find it?

Signature

Peter Marshall
Manager Information Services
Ohio Coatings Company

Reply to this Message

Andy - 13 Dec 2005 14:07 GMT

Hi

Usually Excel gives you the cell reference in the status bar, and puts a
blue dot in the offending cell!

Andy.

>A simple question: when your worksheet has a circular reference, how do
>you find it?

Reply to this Message

Dave Peterson - 13 Dec 2005 14:13 GMT

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

> A simple question: when your worksheet has a circular reference, how do you
> find it?
[quoted text clipped - 3 lines]
> Manager Information Services
> Ohio Coatings Company

Signature

Dave Peterson

Reply to this Message

JE McGimpsey - 13 Dec 2005 14:14 GMT

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...

> A simple question: when your worksheet has a circular reference, how do you
> find it?

Reply to this Message