Enabling Interactive Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2208981%22%20slang%3D%22en-US%22%3EEnabling%20Interactive%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2208981%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EWhen%20I%20enable%20interactive%20calculation%20in%20a%20worksheet%2C%20is%20this%20setting%20or%20function%20enabled%20only%20for%20this%20worksheet%20or%20does%20it%20apply%20to%20any%20other%20worksheet%20that%20I%20open%20and%20work%20on%20later%3F%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2208981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
When I enable interactive calculation in a worksheet, is this setting or function enabled only for this worksheet or does it apply to any other worksheet that I open and work on later?
1 Reply

@hjbrum 

You are probably referring to "iterative computation".

If so, read my comments again.

If it is not the case and I have misunderstood it, please ignore my comment.

 

Once you've activated this option, it will remain active, but only for you.

But it doesn't stay for others.

If you send the worksheet to your co-workers, colleagues or friends, for example, it is not activated.

 

Simplified, if you activate the iterative calculation in a workbook, it remains activated in this workbook even after you open it later.

If you send this workbook to another, the iterative calculation is canceled.

This could of course be dealt with with VBA code.

 

I hope I could answer your question.

 

I also wish you a lot of fun with Excel.

 

Nikolino

I know that I know nothing (Socrates)