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

Use Auto filter... Select the entire worksheet by clicking at top left
portion of the worksheet. Then in a column, filter for blank. All blank
rows will be displayed. Select these and delete.

"Bart" wrote:

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