Thread: change data source of pivot table
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JohnH JohnH is offline
external usenet poster
  
Posts: 27
Default change data source of pivot table
Debora, I get page not found on the link.

Thanks
John


"Debra Dalgleish" wrote:

Ron Coderre has a pivot table add-in that lets you view and edit the
connection string and command text:

http://www.contextures.com/xlPivotPlay01.htm

JohnH wrote:
I thought I posted this question awhile ago but can't find it. Sorry if it's
a dup. I created pivot tables using a test sql data source. Now I want to
chage the data source to my production sql. I dontt see any way to select a
new data source? Excel 2003 & SQL 2000. I'd hate to have to recreate all the
worksheets.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Reply With QuoteReply With Quote