| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 change data source
In Excel 2007, I set up a pivot table based on a range of cells in
another spreadsheet within my workbook. I put that data into a SQL table and now want to base the pivot table on that external data source. When I go to the change data source option in the pivot table menu, in the resultant dialog box, the radio button to connect to external data source is grayed out. What am I missing? Bart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specify date source for x-axis (adjacent to data column in Excel) | Charts and Charting in Excel | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Threaded Mode
