Sorry, the last letter is missing. It should be:

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

JohnH wrote:
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





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