Execute code after OLAP connection refreshes

[Polis]

Hi there, I have created a set of reports containing cube functions (reports are connected to OLAP). What I need is for my code to continue executing as soon as the OLAP connection refresh has finished. Now, the code carries on whilst the refresh is still happening.. This results in reports being saved with "VALUE" errors in it. I did a research into this to find: 1) BackgroundQuery property always FALSE for OLAP (therefore of no use) 2) wait command stops also the Refresh of data. I was amazed by the flexibility of cube functions for reporting and converted all the pivot tables (OLAP) into functions. I am very dissapointed now that I cannot use VBA code to refresh the data. Any help would be very much appreciated. I can post the code if needed. Thank you. Vojta