| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 change pivot data source
I have a pivot attached to a list on a tab in the same workbook. When I
click on the Change Data Source option, the "Use an External Data Source" button is greyed out (I have a connection created already which I could select). How can I change the pivot from a local to an external data source? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 change data source | Excel Discussion (Misc queries) | |||
| change data source of pivot table | Excel Discussion (Misc queries) | |||
| change the ODBC data source of a pivot table | Excel Discussion (Misc queries) | |||
| Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
Threaded Mode
