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=></a><br /> is a good source on excel pivot information. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.