VBA to wait untill first refresh finishes then continue the second refresh

[jjkh58]

Hi guys,

I have a report that needs to be refreshed twice before I can work on other stuff.

So what I usually do is go to Data - > Refresh All Then once the first refresh is completed, I press Ctrl+Alt+F5 to refresh for the second time.

Its refreshing multiple power queries with multiple tabs. The current code that I'm using but not working are below.

All other execution must be stopped before the first refresh is completed and needs to continue for the second refresh. Again, all other execution must be stopped until the second refresh finishes. Please help! Cheers.


Sheets("Sales Data").Select
Activeworksheets.RefreshAll
DoEvents

Sheets("GP by Department").Select
Activeworksheets.RefreshAll
DoEvents

 

[Marc L]

Hi,​

​

as explained in the VBA help for RefreshAll - a must read ! - you can edit the BackgroundQuery property of each object to refresh …​

 

[jjkh58]

Hi,​

​

as explained in the VBA help for RefreshAll - a must read ! - you can edit the BackgroundQuery property of each object to refresh …​

Hi Marc,
Thanks for your help. Im quite new to this coding area. Would you be able to explain more in detail please?. How and where exactly should I format my script? Thanks in advance

 

[Marc L]

Not by code, just editing manually the property of each object to refresh …​

 

[ExcelKnut]

jjkh58,

I have the same dilemma you described on April 21 of last year. Did you find a good solution?

Jeff