+ 0 Votes Excel file with circular reference will not display hgasko January 16, 2013 at 9:48pm PST 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?