Hi Excel experts,

is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
"automatic" in the loaded sheet's options?

Thanks!

Michael

Place this in the ThisWorkbook object in the on Open event:

Application.Calculation = xlCalculationManual
and in the Before Close Event
Application.Calculation = xlCalculationautomatic


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Michael Hoffmann" wrote:

Hi Excel experts,

is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
"automatic" in the loaded sheet's options?

Thanks!

Michael