We help IT Professionals succeed at work.
Get Started

Slower performance with Excel

1,893 Views
Last Modified: 2016-11-22
Hi

I have an Excel workbook that has a lot of VBA.  On first use of the workbook a macro is run that populates worksheets with data and formulae, formats worksheets, hides columns/rows.  Since many of the worksheets are pw protected, there are also unprotect and protect steps.  Use is made of screenupdating = FALSE; Calculation = xlCalculationManual and EnableEvents = False.  It takes about 2 minutes to run the macro.

Out of curiosity I used the same workbook on a lower specification PC (a Dell laptop) and I really surprised to see it only took 45 seconds to run the macro.

This is not what I was expecting, particularly given the difference in specification of the PC's.
Main PC - Windows 10 64-bit; Intel i7-6700K @ 4Ghz;  32 GB RAM;  Office 2010 32-bit;

Laptop - Windows 10 64-bit; Intel Celeron 900 @ 2Ghz;  2 GB RAM;  Office 2007 32-bit;

I would really like to know why the VBA takes over twice to run on the much higher specification PC, and if there is anything I can do to improve the performance.  Unfortunately, I cannot provide a copy of the workbook.

The only other application I have running is MS Edge.

Many thanks in anticipation
Alison
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 15 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE