Pivot Table from multiple workbooks

P

posner24

Is it possible to create a pivot table from multiple workbooks or doe
all the data need to be in a single wokbook? I have separate workbook
for each date of the month and need to compile all the data into
monthly view
 
F

Frank Kabel

Hi
you can use the data from multiple worksheets. in the pivot table
wiazrd you have to choose this option on the first dialog page
 
D

Debra Dalgleish

You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a database, or on one worksheet, and
you'll have more flexibility in creating the pivot table.
 
Top