Where are the settings for the "Calculation Options" saved? (Excel

[JoBa]

I´m looking for a way (preferred a GPO) to strengthen the setting
“Excel Options†– “Formulas†– “Calculation Options†– “Workbook
Calculation†i
that the setting is always “Automatic†(no matter if the document opened has
another setting).
Can somebody please tell me, where I can find this setting (registry, gpo
etc...) - or is this setting only saved in the document itself?

Thanks

 

[trip_to_tokyo]

I am not sure if the following answers your question as it is not very clear.
However . . . In EXCEL 2007:-

Office Button (top left hand corner) / Excel Options (towards lower right
hand corner) / Formulas (second option down on left hand side) / in here
(towards the top of the page) make sure that Workbook Calculation is set to
Automatic.

If this posting is helpful please hit Yes.

 

[JoBa]

I know where to find the settings in the gui, but I´m looking for the place
where its saved - don´t know if it´s written to the registry, in a dll or
somewhere else...

 

[Bob I]

It's saved in the workbook.

I know where to find the settings in the gui, but I´m looking for the place
where its saved - don´t know if it´s written to the registry,in a dll or
somewhere else...

: