If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculation-iterations
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? |
#2
|
|||
|
|||
calculation-iterations
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? |
#3
|
|||
|
|||
calculation-iterations
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? |
#4
|
|||
|
|||
calculation-iterations
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? |
#5
|
|||
|
|||
calculation-iterations
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? |
#6
|
|||
|
|||
calculation-iterations
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? |
Thread Tools | |
Display Modes | |
|
|