| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
