Prev: Windows Scheduled Tasks
Next: from "date" to "text"
From: John7100 on 29 Apr 2010 19:55
When I open my xls file (2003) I keep getting a circular reference error
message.
I can't find the cell among the numerous sheets.
?
Also I found it once & checked it using the precedents button & it looked
alright but I keep getting the error. Is the circular reference error message
always always right ?
From: Dave Peterson on 29 Apr 2010 20:31
You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

John7100 wrote:
>
> When I open my xls file (2003) I keep getting a circular reference error
> message.
> I can't find the cell among the numerous sheets.
> ?
> Also I found it once & checked it using the precedents button & it looked
> alright but I keep getting the error. Is the circular reference error message
> always always right ?

--

Dave Peterson
From: ozgrid.com on 29 Apr 2010 20:55
Click through you Worksheets while looking at the Status Bar. The cell
address will appear on it when you activate the problem sheet.



--
Regards
Dave Hawley
www.ozgrid.com
"John7100" <John7100(a)discussions.microsoft.com> wrote in message
news:BA37DAE9-D91B-4054-B7EF-C96DE2A3ECDD(a)microsoft.com...
> When I open my xls file (2003) I keep getting a circular reference error
> message.
> I can't find the cell among the numerous sheets.
> ?
> Also I found it once & checked it using the precedents button & it looked
> alright but I keep getting the error. Is the circular reference error
> message
> always always right ?

 | 
Pages: 1
Prev: Windows Scheduled Tasks
Next: from "date" to "text"