Installing QuantLibXL forces Excel AutoCalc to ON

[newbie73]

After installing QuantLibXL, I noticed Excel's AutoRecalculate feature is always set to ON.  This is true even after uninstalling the QuantLibXL.

This should be changed so as not to disrupt current system configurations.  It's certainly been a PITA during testing over on my end. :)

- Luis

[Eric Ehlers-2]

Hi Luis,

On Tue, April 22, 2008 18:51, newbie73 wrote:
>
> After installing QuantLibXL, I noticed Excel's AutoRecalculate
> feature is
> always set to ON.  This is true even after uninstalling the
> QuantLibXL.

With regard to the setting Calculation = Manual/Automatic...
The first time you open a workbook in a given instance of
Excel, the Calculation mode is set to whatever value was
associated with that workbook when last it was saved.  This
value for the Calculation mode persists for the remainder of
the Excel session unless it is manually changed in the menu.
For more detail, see the link below:

http://support.microsoft.com/kb/214395

Installing/uninstalling QuantLibXL has no impact on this
behavior.  To resolve the issue, you should identify the first
workbook that is opened (whether by hand or by some
initialization routine) when Excel is started, and determine
the calculation mode associated with that workbook.

Regards,
Eric



-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Ferdinando M. Ametrano-3]

On Tue, Apr 22, 2008 at 7:51 PM, newbie73 <[hidden email]> wrote:
>  After installing QuantLibXL, I noticed Excel's AutoRecalculate feature is
>  always set to ON.  This is true even after uninstalling the QuantLibXL.

let me add to Eric's note that the QLXL VBA policy is that wherever
the calculation is switched to Manual it is then later switched back
to its original state, whatever it was. Of course there might be
undetected policy-breach waiting for a fix...

ciao -- Nando

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users