Refreshing data of OLAP formulas RRS feed

  • Question

  • I have a spreadsheet that uses data from an OLAP cube.  I'm using OLAP formulas as a means of accessing the data.

    All of that works.  My problem is I want to set up a macro that can be run from a scheduled task where I open the spreadsheet, have the data refresh then print the spreadsheet.  My problem is that the macro gets to the print statement and will print it while the sheet is still being refreshed.  I need a way to not print until the refreshing is finished.  I've tried several things and nothing works.

    Any suggestions?



    Tuesday, January 29, 2008 3:26 PM