| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing data source in a pivot
I have a working pivot table, but need to change the data source to a
different database. Can not find an option to do this, anyone know how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing data source in a pivot
In the pivot table wizard, click the Back button.
"John R" <John wrote in message ... I have a working pivot table, but need to change the data source to a different database. Can not find an option to do this, anyone know how? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing data source in a pivot
Hi
In addition to Bob's reply, if you are dealing with connections to an External data source, Ron Coderre has written a nice utility which can be found at Debra Dalgleish's site http://www.contextures.com/xlPivotPl...ml#SrcSettings -- Regards Roger Govier "John R" <John wrote in message ... I have a working pivot table, but need to change the data source to a different database. Can not find an option to do this, anyone know how? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing data source in a pivot
Thanks, this is perfect!
"Roger Govier" wrote: Hi In addition to Bob's reply, if you are dealing with connections to an External data source, Ron Coderre has written a nice utility which can be found at Debra Dalgleish's site http://www.contextures.com/xlPivotPl...ml#SrcSettings -- Regards Roger Govier "John R" <John wrote in message ... I have a working pivot table, but need to change the data source to a different database. Can not find an option to do this, anyone know how? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing data source in a pivot
In Office 2007 click on the data tab.
On the Connections box click properties. Go to the Definition Tab Click on the Edit Query Button This might help. "John R" wrote: I have a working pivot table, but need to change the data source to a different database. Can not find an option to do this, anyone know how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| change data source of pivot table | Excel Discussion (Misc queries) | |||
| Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
Linear Mode
