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
>
>