VBA for updating data from SQL one by one

[glaedr]

Hi,

I have a problem with updating my workbook via refresh all button.

I think the problem is in a large amount of SQL queries in a workbook.

Is it possible to write a VBA macro for updating data connection one by one?

Thank you!

John.

[dflak]

The code to refresh a specific connection is:

Please Login or Register  to view this content.

If you go to Data -> Connections and click on a connection and then click on properties, one of the properties is to allow background refresh. If you turn this off for all the connections, they will be run sequentially. I don't know if that will help. I generally turn off background refresh so my vba stops and waits for the connection to finish updating before I do things like refresh pivot tables.