Ciruclar Reference

's Computer Specifications

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

--
Peter Marshall
Manager Information Services
Ohio Coatings Company

's Computer Specifications

Hi

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

Andy.

"Peter Marshall" <(E-Mail Removed)> wrote in message
news:uPfJjz%23$(E-Mail Removed)...
>A simple question: when your worksheet has a circular reference, how do
>you find it?
>
> --
> Peter Marshall
> Manager Information Services
> Ohio Coatings Company
>

's Computer Specifications

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

Peter Marshall wrote:
>
> A simple question: when your worksheet has a circular reference, how do you
> find it?
>
> --
> Peter Marshall
> Manager Information Services
> Ohio Coatings Company

--

Dave Peterson

's Computer Specifications

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

In article <uPfJjz#$(E-Mail Removed)>,
"Peter Marshall" <(E-Mail Removed)> wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When I reference a cell in a separate list, I am unable to sort thatlist and keep the reference. Any suggested solutions?	Mike C	Microsoft Excel Discussion	2	15th Feb 2008 02:32 PM
Insert reference/cross-reference doesn't display my header text	=?Utf-8?B?QmFiczI1?=	Microsoft Word Document Management	3	24th Oct 2007 01:49 PM
ASP.NET 2.0: master pages and web user controls: reference to a non-shared member requires an object reference	bminder	Microsoft ASP .NET	0	24th Jun 2005 01:22 AM
Visual Basic .Net IDE Add-In that adds a Web Reference or Normal Reference to Current Project	Bahige	Microsoft VB .NET	0	1st Nov 2004 06:24 PM
Word 2002 cross reference problem: Error! Reference source not found	Sam Dutton	Microsoft Word Document Management	0	31st Mar 2004 02:49 PM