PC Review


Reply
Thread Tools Rate Thread

Deactivaion of recalc on load

 
 
Michael Hoffmann
Guest
Posts: n/a
 
      1st Apr 2008
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



 
Reply With Quote
 
 
 
 
Michael
Guest
Posts: n/a
 
      1st Apr 2008
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
>
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:34 PM.