Answer for:

Circular Reference Warning

Message 7 of 8

View entire thread
0 Votes

I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?