none
refresh of cube formulas RRS feed

  • Frage

  • Hi there,

     

    in a sheet containing cube formulas, when refreshing them all we need to be able to "catch" the event when the last formula has been refreshed and thus the whole refresh is completed.

    A basic sample code would be like this:

     

    ActiveWorkbook.Refresh

    MsgBox "refresh has completed"

     

    Now when executing this code, the MsgBox is displayed before the refresh has been finished, when clicking 'OK' and closing it, refreshing of the cube formulas continues until the end.

     

    Thanks a lot for any hint

     

    I just notice this is the German forum, you can forward it to the Englisch one, if needed. Thank you.

     

    Dienstag, 21. Dezember 2010 19:45