Excel 2016 and ASAP Utilities

Dr. Logic

Board Regular
Joined
Jul 13, 2005
Messages
218
I can't seem to get ASAP utilities to run well with excel 2016 large workbooks with macros - in my old Excel 2010 there was no undo feature for the ASAP macros and that was okay - now in Excel 2016 the undo feature in excel works but it makes the ASAP macros so slow that ASAP is useless.

Anyone else have this issue? It seems to be an issue in a large spreadsheet with many formulas and macros. It worked fine in 2010, but not in 2016. Same file in fact.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
I would point that to ASAP themselves, they are constantly improving their interface. I use it but only for stuff I can't do easily in excel
 
Upvote 0
Your right - they contacted me - there is a feature in ASAP under Utilities, Options, Settings that allows you to turn off the undo feature - that made the ASAP real fast again the way I like it.
 
Upvote 0

Forum statistics

Threads
1,223,805
Messages
6,174,723
Members
452,578
Latest member
Predaking

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top