Excel 2016 Macros running slow

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Excel 2016 Macros running slow

FAQ

Thread Tools

Display Modes

01-13-2016, 02:59 PM

OldAl

Mac OS X

Office 2016

Novice

Join Date: Jan 2016

Location: Ridgecrest, CA

Posts: 4

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

Tags

macros, vba code

« Previous Thread | Next Thread »

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 05:19 AM.