Iteration or Circular reference formulas

[Rick Lenihan]

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

 

[Max]

One guess:

The first file.xls opened during an Excel session
sets the Options for the whole session, until you exit Excel.

If the first file opened for the session was not earlier saved with
"Iterations" checked
(which is probably the case, by default) then you'll hit the error message.

Try exiting Excel first.

Then open your file (saved with the option for "Iterations" checked).

You shouldn't hit the error.

 

[Guest]

Thanks that was it it seems fine now.

-----Original Message-----
One guess:

The first file.xls opened during an Excel session
sets the Options for the whole session, until you exit Excel.

If the first file opened for the session was not earlier saved with
"Iterations" checked
(which is probably the case, by default) then you'll hit the error message.

Try exiting Excel first.

Then open your file (saved with the option for "Iterations" checked).

You shouldn't hit the error.




.

 

[Max]

you're welcome ! Thanks for feedback. cheers.