Hi Carissa

Take a look at Ron Coderre's addin
http://www.contextures.com/xlPivotPlayPLUS01.html

--
Regards
Roger Govier

Carissa wrote:
I have several pivot tables connected to an OLAP cube. However, the server
hosting our cube has been migrated to a new location. So I need to re-direct
my pivot tables to pull source data from the correct location. How would I
do this?