Pivot Table/Multiple Workbooks

  • Thread starter Thread starter fnse
  • Start date Start date
F

fnse

Is there anyway to create a pivot table using information
from multiple workbooks (not worksheets?)

I have 3 files:
count1.xls
count2.xls
count3.xls

All files have same headers but each file represents a
different month. How can I create a pivot table using
these 3 excel files?

I also want the pivot table to get updated everytime I
make a change to one of the excel files.

If this is doable, what is maximum number of files that I
can link to that pivot table?

Thanks.
 
You can use a pivot table across mulitple workbooks by using the "Multiple
Consolidation Ranges" in the pivot table wizard. It is probably easiest to
open all the workbooks before starting the wizard.

Neal
 

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 using multiple workbooks 1
Pivot Tables 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table Data Source 1
Cannot Open Pivot Table Source File 0
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Tables 3
Pvt Table Turned Into Static Values 1

Back
Top