D
Dave
I am working in a spreadsheet where I need circular references in my
calculations. I have iteration turned on to allow this. If I have automatic
calculation turned on, whenever I open the workbook, all the cells that are a
part of the circular reference displa the #value! error. When I turn on
manual calculation, the cells do display the correct information right after
I open the workbook. But when I use F9 or CTL-ALT-F9 or any of that the
spreadsheet doesn't calculate. After I make a change, the 1st time I hit F9
nothing happens at all. The 2nd time I hit F9, the cells with formulas
dependemt on the changes I made display th #n/a eror. The 3rd time I hit F9,
those same cells display th #value! error. After that hitting F9 does
nothing, and I have to reopen the workbook to get rid of the errors. Please
help.
Thanks,
Dave
calculations. I have iteration turned on to allow this. If I have automatic
calculation turned on, whenever I open the workbook, all the cells that are a
part of the circular reference displa the #value! error. When I turn on
manual calculation, the cells do display the correct information right after
I open the workbook. But when I use F9 or CTL-ALT-F9 or any of that the
spreadsheet doesn't calculate. After I make a change, the 1st time I hit F9
nothing happens at all. The 2nd time I hit F9, the cells with formulas
dependemt on the changes I made display th #n/a eror. The 3rd time I hit F9,
those same cells display th #value! error. After that hitting F9 does
nothing, and I have to reopen the workbook to get rid of the errors. Please
help.
Thanks,
Dave