i have tried this a couple of times and it keeps causing excel to crash just
after i turn off the auto refresh?

"Tom Ogilvy" wrote:

Turn on the macro recorder and do it manually to one of your queries.

then turn off the macro recorder and look at the code recorded.

--
Regards,
Tom Ogilvy


"Patrick Bateman" wrote:

sorry i'm looking to disable the automatic refresh on a database query i have
in my sheet

"ddiicc" wrote:


Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic

This is stop screen updating while running macro and will actually speed up
the macro by 80%. If you want screen updating, just change the FALSE to TRUE

"Patrick Bateman" wrote:

hi

is it possible to run a macro to disable/enable the automatic refresh on all
queries in a workbook?

thankyou