Circular reference error closes workbook

S

SteveH

When I one a certain workbook I get a dialog box saying I have a circular
reference. If I click OK or Cancel the workbook saves and exits. I can find
and deal with circular references but I can't keep the workbook open. Can
anyone help?

Steve H
 
D

Dave Peterson

Just a wild guess....

Try opening excel in safe mode:

Close Excel
windows start button|run
excel /safe

File|open your workbook

If it stayed open, fix the circular reference and save.

Then close excel and try opening it normally.
 
Top