I have a circular reference designed to iterate and recalculate when I
change an input cell. When the input cell causes the calculation to result
in a ##NULL value I have to click on one of the cells in the circular
reference, then click on the formula bar and then press enter before it will
recalculate even if the input cell is a safe value. Does anyone know a way
to reset or refresh the cells in the circular reference other than the
onerous one that I have discovered?

Thanks.