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.



Debra Dalgleish

You could start by selecting a cell in the BidBookData table.
Insert a pivot table, and select a sheet in WorkbookB as the destination.

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