| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Circular Reference | Excel Worksheet Functions | |||
| Circular Reference | Excel Discussion (Misc queries) | |||
| Circular Reference??? | New Users to Excel | |||
| IF Function - If the reference cell data is presently unknown | Excel Worksheet Functions | |||
| How to find out merge cells from unknown position | Excel Discussion (Misc queries) | |||
Hybrid Mode
