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