When I set a sheet with the itereations checked so it does not give a
circular reference, the word "calculate" appears in the bottom of all sheets
I open in the day until I close excel and open again.

I don't know the effect of having "calculate" there, but it normally is not
there.

"Niek Otten" wrote:

leave other sheets working normally

What exactly do you mean by that?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"widman" wrote in message
...
Is there any way to set 1 worksheet for iterations so that it doesn't
return
the circular reference, but leave other sheets working normally?