Iteration or Circular reference formulas

Giganews Newsgroups
Subject: Iteration or Circular reference formulas
Posted by:  Rick Lenihan (anonymo…@discussions.microsoft.com)
Date: Tue, 28 Oct 2003

Maybe some one can help me on this  I have a spreadsheet
that uses a circular reference in 2 columns.  I basically
have a total in column b and enter new figures in column c
then enter a zero to clear out.  The formula works fine I
set iteration values to 1 Max and 1 Min.  Herin lies the
problem the spreadsheet stays OK for 2 or 3 days after I
have changed the options then the next time i open the
file I get the circular reference error and when I check
the option tab for calculation iteration is unchecked.  Is
this a bug in the program?

You're help would be appreciated

Replies