Excel 2007 change data source

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table change data source 1
Excel 2007 pivot table source table 1
Change pivot table source data in Excel 2007 1
Use named table in workbook as source for pivot tbl in other workb 1
pivot table source data expand to new entries when refresh? 4
Refresh order when refreshing all in a workbook 1
Column limit for Pivot Table data source 1
How can I change the source data reference to another pivot table? 2

Top