Cube Values Timing Out When Batch Printing PDFs

[joeybb]

Hey snb, you're actually spot on, the range is tied to the slicer, so as the macro goes through each value in the slicer list, that value is populated into X1 so the save macro will save with whatever data is being displayed... Basically the value that's in cell X1 is:

=CUBERANKEDMEMBER("PowerPivot Data",Slicer_1,1)