Turn off calculations before query refresh....turn them back on after

**mk3ll00** · 05-30-2014, 11:43 AM

I have a workbook with a lot of formulas and several queries and I would like to speed up the speed by having the calculations turn off at the beginning of this macro and having them turn back on when all the queries have finished refreshing.

Please Login or Register  to view this content.

I created a class module with this code

Please Login or Register  to view this content.

but I must be missing something because it's not working. I am using excel 2010.

thanks

**ImStevenB** · 05-30-2014, 01:28 PM

Have you tried putting

Please Login or Register  to view this content.

at the beginning .. and putting

Please Login or Register  to view this content.

before the End Sub of your updateorders macro?

**mk3ll00** · 05-30-2014, 03:25 PM

Yes, I tried that but despite the order they are listed in the Queries don't referesh untill the very end. I tried the same thing with a delay involved but still no luck