Excel 2007 change data source

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

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.
 
Back
Top