How to change data source in Pivot Table? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to change data source in Pivot Table?

How do I change an external data source to point to a different SQL Server in an Excel 2002 pivot table? Thanks, Dave
Have you saved the query in a *.dqy file? <br />If so, open the dqy.file with an editor and modify it. Otherwise you might be better off asking this in an Excel-related community. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
http://www.exceluser.com/help/formula/long001.htm is a good source on excel pivot information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>