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.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,346
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:

Watch MrExcel Video

Forum statistics

Threads
1,099,154
Messages
5,466,976
Members
406,513
Latest member
t0ny84

This Week's Hot Topics

Top