XL97: Error Creating Circular References Between Instances

MORE INFORMATION

In Microsoft Excel, a circular reference is formed when a cell refers to itself through one or more other cells. For example, both of the following sets of formulas create circular references

   A1: =B1      E1: =F1
   B1: =A1      F1: =G1+K2

                G1: =E1
				

because at least one of the cells refers to itself through other cells.

Microsoft Excel warns you if you create a circular reference, either by displaying a dialog box or by displaying a message in the status bar.

However, if you create a circular reference between cells in different instances of Microsoft Excel, you are not warned about the presence of the circular reference. Also, depending on the way you quit Microsoft Excel 97, you may receive an invalid page fault when you close the second instance of Microsoft Excel 97.