Circular Reference

I have a workbook that has developed a circular reference that I cannot track down. I keep getting a circular reference window telling me to click on the view, toolbars link. In other workbooks I have closed the popup, clicked on the View, Toolbars link and followed the link to the problem but in this case there is no circular reference display. I have run across this before but have always seen a window that I can use to trace the source. Without a circular reference window to tell me where the problem is I am stuck. Any ideas?


JIm O

I guess it didn't just get there on its own ;-) So what have you changed recently? Do you have any earlier version(s) of the workbook? Backups that you can compare the current version with?

If it's not sensitive data, you could upload it for investigation. If it is sensitive, maybe you can anonymise it and then upload it.

Regards

can you upload your workbook? didn't refresh!

Does the status bar give any indication?

I've just set up a circular reference A1>B1>C1>A1 and the status bar says: Circular: A1

If you wish, you can mail it to my hotmail account. That would be TMShucks at ... .com

Regards

i cant see any errors but i've opened this in 97 err yes i can but cant trace it

Hi Jogier505,

The circular formula is originating from cell AM3 from the "All Data" tab.

HTH

Robert