Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2015, 01:14 AM
Neels_MSExcel2016 Neels_MSExcel2016 is offline Excel 2016 Macros running slow Windows 7 64bit Excel 2016 Macros running slow Office 2016
Novice
Excel 2016 Macros running slow
 
Join Date: Nov 2015
Posts: 1
Neels_MSExcel2016 is on a distinguished road
Default Excel 2016 Macros running slow


Hi - I was using Excel 2010 and with a large number of VBA macro codes.
I install Excel 2016 from the 365 office pack and now my macro is taking a long time to run where it only took a few seconds in Excel 2010.
Why is this and it there a solution to this without changing my VBA code?
I am using Windows 7 (64).
Reply With Quote
  #2  
Old 01-13-2016, 02:59 PM
OldAl OldAl is offline Excel 2016 Macros running slow Mac OS X Excel 2016 Macros running slow Office 2016
Novice
 
Join Date: Jan 2016
Location: Ridgecrest, CA
Posts: 4
OldAl is on a distinguished road
Default

I had the same effect going from Mac 2011 to 2016.
Application.Screenupdating = false helps but the speed is still miserable. The screens go blank while things are calculating.

You need to follow-up with Application.Screenupdating = true when your done.
I don't know if this is available in Windows
Reply With Quote
  #3  
Old 01-14-2016, 02:48 AM
Debaser's Avatar
Debaser Debaser is offline Excel 2016 Macros running slow Windows 7 64bit Excel 2016 Macros running slow Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

What does your code do? I find each succesive version gets a little slower but there shouldn't be a massive difference in speed - unless you are protecting and unprotecting sheets.
Reply With Quote
  #4  
Old 01-14-2016, 10:53 AM
OldAl OldAl is offline Excel 2016 Macros running slow Mac OS X Excel 2016 Macros running slow Office 2016
Novice
 
Join Date: Jan 2016
Location: Ridgecrest, CA
Posts: 4
OldAl is on a distinguished road
Default

I don't know specifically what it does. I seems to just avoid sending signals to the screen i.e. leaves them blank. My stuff doesn't have any protect/unprotect commands but does have lots of charts and sort commands. For macros that are just calculations and no charts to update the slowness is not nearly as apparent.
The Mac Excel 2011 has the no-screen-updating built in but doesn't blank out the screens -- it just didn't update anything until it is done with the macros. Much, much Better.
Reply With Quote
  #5  
Old 01-15-2016, 02:36 AM
Debaser's Avatar
Debaser Debaser is offline Excel 2016 Macros running slow Windows 7 64bit Excel 2016 Macros running slow Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

I was talking to the OP.
Reply With Quote
  #6  
Old 05-18-2016, 01:37 AM
bahavar bahavar is offline Excel 2016 Macros running slow Windows 7 64bit Excel 2016 Macros running slow Office 2016
Novice
 
Join Date: May 2016
Posts: 1
bahavar is on a distinguished road
Default

i have the same problem, but i found when macro is running, press Ctrl + Break to stop running then select "edit". after VBA windows show press F5 to resume ... now macro run quickly.
Reply With Quote
Reply

Tags
macros, vba code

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros are VERY slow to run wxtoad Excel Programming 12 09-09-2014 06:11 PM
Quick Access Toolbar/Macros not running salbergotti Word VBA 1 07-06-2014 06:40 PM
Running Excel from a webpage jimbassett Excel 0 04-22-2014 02:11 PM
Running total in Excel chart jen152638 Excel 0 06-14-2010 05:38 AM
Excel 2003 SP3 bug when running Macros EnricoVenturi Excel 0 09-06-2009 08:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft