![]() |
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 ? |
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 |
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