Identify Data Source Update Complete

mgrady11

New Member
Joined
Apr 18, 2017
Messages
11
Is there a way to identify when a data source has completed updating? We have a lot of processes that are sequential and require a data source to be update prior to running the next step in the process. Currently, we are basically, hitting one button and waiting the source data to update, then hitting the next button to start the next part of the process. However, if there was a way to identify when the source "completed" the update and then told excel to wait for that instance then continue. We have gone down many avenues, including pretty in-depth VBA and still do not have a good/usable solution.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
what is 'data source', and how do data sources update?

if they are some sort of query, (via VBA) explicitly update them sequentially, and be sure that backgroundquery = false

that setting should ensure that no process start until the update of a query is done
you could throw in a DoEvents 'just in case'

if the queries cascade, be sure to have them in the correct sequence

basic idea being like below, (pseudo code)
datasource_1.refresh backgroundquery:=false
doevents
datasource_2.refresh backgroundquery:=false
doevents
datasource_3.refresh backgroundquery:=false

if this isn't helpful, then please provide some details of the setup as it isn't clear, to me at least

if there is in depth VBA, consider posting it

regards

PS, if it is an OLAP query, they can not be refreshed in the background AFAIK
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

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