Control the OLAP Cube Value updating in Excel 2007 Workbook
I posted this question the other day and rceived a couple suggestions but
nothing I've tried has worked ... so I'm reposting in case a freash set of
eyes are out there. Here goes...
I have a Excel 2007 worksheet that makes a connection to a OLAP Cube on a
server.
When I change a cube member, i.e., a parameter, the cube values update
themselves automatically.
When the parameter change is made programatically, the program execution
will NOT wait for the cube values to resolve before moving up to the next
line of code. This is obviously no good when the next line of code is to
print the worksheet.
How can I make the program wait allowing it to update the cube values before
moving on?
Thanks,
Mark
|