Screenupdating excel performance

posted by | Leave a comment

It is not unusual for properly edited recorded macros to be 20% of the size of the original, and to run 10 times faster. The code is virtually all written by hand and when I did use the macro recorder I edited the code. The results are as follows: Main PC - Overall score 3477.9 Laptop - Overall score 209.1 Thanks Alison Alison, The Performance Test score definitely confirms that your main PC is more muscular than the laptop.Does your workbook need to establish links to other workbooks on a network?If you set Calculation to xl Calculation Manual at top of each sub, then restore it to xl Calculation Automatic at the bottom, that will force a workbook recalculation at the end of each sub. Does your workbook need to establish links to other workbooks on a network? Anti-malware & anti-virus software - Microsoft Defender is used on both machines.Do you have several macros running in succession when the workbook is first used? Application settings are initially set at the beginning of the main procedure, but there are certain places within the code where a screenupdate and a recalc are required.Hi I encountered a problem when attempting to install 2010. Its specification is Windows 10 32-bit; Intel Core(TM) 2 Duo T7100 @ 1.8Ghz; 2 GB RAM; Office 2010 This takes 47 seconds to run the macro.So 2 laptops with Office 2007 and Office 2010 return almost the same timing, yet their hardware specification is inferior to my main PC which takes more than twice as long.The benchmark score is now 5130 (previously it was 3477.9) and the VBA in the Excel workbook is executed a lot faster.It is quicker than running on the laptop, but some parts of the VBA in 2016 execute slower than 2010 and therefore need to be improved.

Have you ever run Microsoft's Configuration Analysis tool Off CAT?

The only other application I have running is MS Edge.

Many thanks in anticipation Alison Hi Brad I upgraded to Office 365 and I still had a performance problem.

So there was something wrong with my PC setup before which will remain a mystery. Alison The only fair comparison would be to have Office 2007 32-bit installed on the Main PC.

If it now wins with for instance 20 seconds, it's an Office issue, not a hardware issue.

After changing these application settings to True they are changed back to False as soon as possible.

Leave a Reply

  1. fun dating online for singles 11-Sep-2018 13:12

    value starts here No matter how your customers want to engage — through chatbot, dynamic search bar, or virtual agent — Bold360 harnesses artificial intelligence to make self-service more engaging and intuitive.

  2. are zac efron and vanessa still dating 2016 19-Dec-2018 02:16

    Swingers who engage in casual sex maintain that sex among swingers is often more frank and deliberative and therefore more honest than infidelity.

  3. Totally free sex dating site no upgrade needed 12-Oct-2018 12:36

    As I share this, I realize I have no “proof,” but every indication points to the “real” reason for my unjust excommunication.

  4. todating com 19-Jan-2019 08:55

    Unfortunately, the English localization is censored which takes some of the edge off.

lovedatingmarriage com