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 |
Excel 2007 change data source
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 |
All times are GMT +1. The time now is 04:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com