| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change data source of pivot table
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. Thanks John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
Click inside your existing PT; Goto the menu, Data, Pivot Table..
this should bring up the Wizard; Step thru to Step 2 of 3 - there change the data source (BROWSE...). "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. Thanks John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
Jim, I've tried that. I immedately go to step 3 of 3 and all I can do is
reposition the table to a new cell. I get no option to change the data source. Thanks John "Jim May" wrote: Click inside your existing PT; Goto the menu, Data, Pivot Table.. this should bring up the Wizard; Step thru to Step 2 of 3 - there change the data source (BROWSE...). "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. Thanks John |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
Debra,
I got to the site and sucessfully installed the add-in. I think it works? I'll have to move the excel file and run the sql SP on the production data to find out. Thanks much. And thanks to Ron Coderre as well. "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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
You're welcome, and I hope it works for you.
JohnH wrote: Debra, I got to the site and sucessfully installed the add-in. I think it works? I'll have to move the excel file and run the sql SP on the production data to find out. Thanks much. And thanks to Ron Coderre as well. "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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
I also tried to download the add-in to help me with my issues but I get run
time errors when running the application. I didn't see that it needed to be run in any specific version of Excel. "Debra Dalgleish" wrote: You're welcome, and I hope it works for you. JohnH wrote: Debra, I got to the site and sucessfully installed the add-in. I think it works? I'll have to move the excel file and run the sql SP on the production data to find out. Thanks much. And thanks to Ron Coderre as well. "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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change data source of pivot table
I'm sorry that you had problems with the application, and thanks for
mentioning it. The add-in was tested in Excel 2003 and Excel 2002, and uses features that weren't available in earlier versions. I've added that information to the page. IMT wrote: I also tried to download the add-in to help me with my issues but I get run time errors when running the application. I didn't see that it needed to be run in any specific version of Excel. "Debra Dalgleish" wrote: You're welcome, and I hope it works for you. JohnH wrote: Debra, I got to the site and sucessfully installed the add-in. I think it works? I'll have to move the excel file and run the sql SP on the production data to find out. Thanks much. And thanks to Ron Coderre as well. "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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table data not matching source | Excel Discussion (Misc queries) | |||
| moving pivot table data source files | Excel Discussion (Misc queries) | |||
| Pivot Table Source Data | Excel Discussion (Misc queries) | |||
| Ctrl-A for new source data in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table in data source order | Excel Discussion (Misc queries) | |||
Linear Mode
