AnsweredAssumed Answered

vrf Disabling Auto update on charts in excel

Question asked by VRFuser on Sep 24, 2008
Latest reply on Sep 24, 2008 by VRFuser
Jacob,

 

What is actually slowing down the process is Excel updating the Screen.

 

Fortunately there is a VBA command for this which is:

 

Application.ScreenUpdating = False

 

Put that at the point in the VBA Script before you generate the data and create the Charts, then after the work is done

 

Put Application.ScreenUpdating = True

 

It is very important to remember that if there is any chance an error can occur during the data creation or charting to put some Error trap in to turn screen updating back on

 

For example:

 

On Error GoTo TurnScreenUpdatBackOn

Application.ScreenUpdating = False

 

 

Then have a label somewhere at the end of the Sub Program

 

TurnScreenUpdatBackOn:

Application.ScreenUpdating = True

Exit sub

 

This will allow you to continue to control Excel.

 

Hope that helps

 

 

Gary Voltz

Technical Officer (SASTO4)

 

Test Equipment Maintenance and Calibration Centre (TEMACC)

Facilities Management Services

Technology and Asset Services

Airservices Australia

 

E-mail: gary.voltz@airservicesaustralia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Airservices Australia

Ph 1300 301 120       (within Australia)

   07 3886 3382

Ph +61 7 3866 3382    (outside Australia) 

Fax +61 7 3866 3531

www.airservicesaustralia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

CAUTION: This e-mail is confidential. If you are not the intended

recipient, you must not disclose or use the information contained

in it. If you have received this e-mail in error, please tell us

immediately by return e-mail and delete the document.

 

Airservices Australia does not represent, warrant or guarantee

that the integrity of this communication is free of errors, virus

or interference.

 

  _____  

From: Meachen, Jacob [mailto:Jacob.Meachen@adckrone.com]
Sent: Wednesday, 24 September 2008 8:01 PM
To: VRF
Subject: [vrf] Disabling Auto update on charts in excel

 

Hi VRF

I have macro which runs in vba in excel. The macro generates lots of data which it puts into cells. The workbook has charts on it when the macro is run excel continuously updates the charts slowing down the process. For example with out any charts the macro take 2.6 seconds to complete with the charts the macro takes 10 seconds.

I have already set Application.Calculation to xlCalculationManual and reset it to xlCalculationAutomatic at the end of the macro, is there a way to disable the automatic updates on the charts as well?

Thanks

Jacob Meachen


---
You are currently subscribed to vrf as: gary.voltz@airservicesaustralia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes