#1
|
|||
|
|||
Refresh of data from external source
I have sheet with formulas for retrievieng external data (OLAP cubes). If any user changes parameters of report (month, department) data are refreshed automatically. But the running macro does not wait until the data are refreshed completely.
Is there any command or any other solution how to stop the macroexecution until the refresh is finished? Or do you have any experience with the data refresh? Jirik |
#2
|
||||
|
||||
Hi jirk,
A crude but effective way is to insert a timed delay into the code. Depending on what code you're using to retrieve the data, you might be able to do something more sophisticated by testing the update state.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Dear Paul,
Thank you for your hint, I made some test in the past and used a couple of commands for delay or wait until keypress, but I failed. For instance - when I used the MsgBox statement, the aplication update nothing until I press the key... for refresh I used : Application.Calculation = xlManual mustek.RefreshAll Application.Calculation = xlAutomatic and then : Application.Wait (Now + TimeValue("0:00:20")) or : MsgBox "Akualizce", vbOKOnly If I debug the application (Step Into) the data are refreshed correctly, and I am not able to make a "step forward" until the data are refreshed completely. Do you have any idea? Thanks! Jirik |
#4
|
||||
|
||||
From what you've described, you've put the delay/message box in the wrong place. Without seeing your code, that's about all I can say.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
drop down list from external data source Excel 2007? | Intruder | Excel | 1 | 08-03-2012 05:41 AM |
vba change external data source | excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
Automatically Selecting a Data Source | Nathan_Newlin | Mail Merge | 1 | 12-06-2011 03:42 PM |
Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
Help w/ external data | bellest | Excel | 0 | 11-11-2005 12:51 PM |