Hi Kostis,

My simplified example is already closed within about 5 IF statements that do
other things. But in the simplest sense, your suggestion just returns a zero
value in cell C1, and all other cells (C2:C5 in my example) calcualate off
this zero value.

Thanks for the suggestion though, any other ideas? I have tried various
things but to no evail.

Thanks,

Bhupinder.

"vezerid" wrote:

Encolose your circular reference formulas in an IF(). Use another cell,
which will hold an initialization value (0 or 1). Say K1.

=IF(K1=0, 0, calculation).

This solves the problem of recalculating at will but it will have the
(possibly) unpleasant effect of displaying 0 at all other times.

HTH
Kostis Vezerides