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