troubleshooting Question

Slower performance with Excel

Avatar of alisonthom
alisonthom asked on
Microsoft ExcelMicrosoft OfficeVBADell
15 Comments1 Solution1904 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
alisonthom

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros