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?

<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?

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?

What do you mean by "links"? Do the cells have regular formulas? Or do you
mean VBA codes? And what happens when you send the file by email? are the
formuals/ vba code there?

Art.

"widman" wrote:

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?

I didn't say anything about links or email.

"art" wrote:

What do you mean by "links"? Do the cells have regular formulas? Or do you
mean VBA codes? And what happens when you send the file by email? are the
formuals/ vba code there?

Art.

"widman" wrote:

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?

Sorry, this reply was posted to the wrong question. Sorry about that.

"widman" wrote:

I didn't say anything about links or email.

"art" wrote:

What do you mean by "links"? Do the cells have regular formulas? Or do you
mean VBA codes? And what happens when you send the file by email? are the
formuals/ vba code there?

Art.

"widman" wrote:

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?