Change the data source of a pivot table

  • Thread starter Thread starter Kevin Dai
  • Start date Start date
K

Kevin Dai

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing OLAP Pivot Table Connection Source 0
Refresh CubeFields for existing Pivot Table on OLAP cube 1
OLAP Pivot Table 1
Changing Data Source on Multiple Pivot Tables at once 1
Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In? 1
Pivot Table question 1
Undo "Convert to formulas" pivot function 1
Excel file with olap cube gets corrupted 1

Back
Top