Using iterations to calculate circular references.

[Guest]

I am working with data that requires using circular references in some
calculations. I checked the "iterations" box to allow for these calculations
to work, and Ecxel seems to be calculating everything correctly. The problem
is that after I close the workbook, when I later reopen it to continue
working, all the cells that are a part of the circular reference display the
#VALUE! error. I can fix this by deleting one cell that is part of the loop
and then undoing that command, or by copying the formula from a cell,
deleting it, and pasting it back into the same cell. I have to do this every
time I open the file. I tried recording this method into a macro, but when I
run it it takes a while since there are multiple sheets with lots of similar
calculations. Is there a better way to make Excel calculate correctly As soon
as I open the workbook?

Thanks,
David

 

[Niek Otten]

Hi David,

Do you use manual calculation? If so, did you check the "Recalculate before
save" box?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

No, I am using automatic calculation. I tried using manual calculation, but
it did no good.