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, DaveHave 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=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
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.
]]>