pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data on an excel spread sheet a workbook which I would like to use to
populate a pivot table in a different work book.is this possible or does the
pivot table need to be in the same work book?
 
A very good question!

The Pivot Wizard does not seem to facilitate this, but I tried this out:

1. open two workbooks
2. create a small table with the Wizard
3. tell the Wizard to put the table on a new worksheet
4. copy the new sheet from the first book to the second book

At this point the data is in book1 and the PT is in book2. I tried changing
the data in book1, went to book2 and the refresh worked just fine.


I never realized this could be done.
 
It gets better. Open the Pivot Table Wizard in a new workbook, choose
External Data Source, select Excel as the data source, point to the workbook
containing the data, follow the wizard. You end up with a Pivot Table linked
to an external workbook. No need to open the data workbook.

Ed Ferrero
 

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 - Changes 5
Single Filter to change all Pivot Tables in a Workbook 8
Easy way to change Pivot table source files? 5
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot tables - memory issues - please help 2
pivot table data 2
Adding to an existing Pivot Table 7
Cannot Open Pivot Table Source File 0

Back
Top