ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help me find a circular reference cells located in unknown multita (https://www.excelbanter.com/excel-discussion-misc-queries/262797-help-me-find-circular-reference-cells-located-unknown-multita.html)

John7100

Help me find a circular reference cells located in unknown multita
 
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

Help me find a circular reference cells located in unknown multita
 
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

ozgrid.com

Help me find a circular reference cells located in unknown multita
 
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" wrote in message
...
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 ?




All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com