Deactivaion of recalc on load

's Computer Specifications

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

's Computer Specifications

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
>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
load=load=load=load=	Janusz Sokolowski	Windows XP Help	0	26th Oct 2004 02:29 PM
Recalc Issue	Alan	Microsoft Excel Discussion	4	9th Aug 2004 10:27 PM
Recalc Challenge	Howard Taylor [o2olap]	Microsoft Excel Discussion	1	9th Aug 2004 06:34 AM
Dynamic Properties - How to turn off automatic recalc???	Lee	Windows XP Internet Explorer	0	3rd Mar 2004 06:25 PM
recalc question	Bura Tino	Microsoft Excel Programming	2	10th Jul 2003 02:47 PM