Hi All,
I've got an issue where I'm trying to get sales from our Sales Cube & Stock Cube to automatically update. Using the CUBEMEMBER & CUBEVALUE formulas I can reproduce the original Pivot table and it will fetch the data.
My problem is as follows. The CUBEVALUE & CUBEMEMBER formulas will not update until the macro has stopped running. As I want the macro to keep going and move the data to another sheet, this is causing a problem.
My only solution so far is to end the macro, wait till the update of data is complete, then run a second macro with the data moving in it.
I've tried using Application.Wait & Sleep to no effect. The data still wont update until the macro has finished.
I've also tried to turn off Background Updating on the data connections, but for a reason escaping me, the option is greyed out.
I'm currently using Excel 2010 on Vista.
Thanks in advance for your help!
Adam.
I've got an issue where I'm trying to get sales from our Sales Cube & Stock Cube to automatically update. Using the CUBEMEMBER & CUBEVALUE formulas I can reproduce the original Pivot table and it will fetch the data.
My problem is as follows. The CUBEVALUE & CUBEMEMBER formulas will not update until the macro has stopped running. As I want the macro to keep going and move the data to another sheet, this is causing a problem.
My only solution so far is to end the macro, wait till the update of data is complete, then run a second macro with the data moving in it.
I've tried using Application.Wait & Sleep to no effect. The data still wont update until the macro has finished.
I've also tried to turn off Background Updating on the data connections, but for a reason escaping me, the option is greyed out.
I'm currently using Excel 2010 on Vista.
Thanks in advance for your help!
Adam.
