I have an excel front end (with lots of pivot tables) that looks at data from
a cube from access. I want to use the same front end sheets (that contain
lots of pivot tables), but want them to look at a different cube. At the
moment, I have to change this in each pivot table in each sheet separataly.
I have about 50 sheets. I want to be able to point each one to the different
cube.

Is there an easy way to do this???