| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use named table in workbook as source for pivot tbl in other workb
In Excel 2007 I have a table named BidBookData on Sheet 1 in Workbook A. I'd
like to create a pivot table in Workbook B that uses the data in the BidBookData table in Workbook A as the source. Inside Workbook B when I try to create the pivot table using Insert, Pivot Table,Use an external data source, choose connection,browse for more...I can navigate to Workbook A but it doesn't list BidBookData as a table in Workbook A. All it shows is Sheet1. Is there any way to connect to a specified table? I know the table exists in Workbookk A because I can see it listed as the table name under Table Tools in Workbook A. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy pivot table and source from workbook 1 to 2. | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| Transforming pivot table back to the source table | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Threaded Mode
