Change the data source of a pivot table

I have a pivot table which is linked to a SQL Server OLAP Cube. The OLAP
source is on a development server. Now I want the pivot table link to OLAP
cube on another production server. How canI change the data source?

Thanks in advance
Kevin

Kevin

You could try changing the SQL statement in MSQuery to the new database.
Here's an earlier exchange

http://tinyurl.com/a26dl

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Kevin Dai" <Kevin_Dzy@Hotmail.com> wrote in message
news:%23XCsBBXdFHA.2212@TK2MSFTNGP14.phx.gbl...
>I have a pivot table which is linked to a SQL Server OLAP Cube. The OLAP
>source is on a development server. Now I want the pivot table link to OLAP
>cube on another production server. How canI change the data source?
>
> Thanks in advance
> Kevin
>
>