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