How to use mutiple spreadsheets in a pivot table?

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

Guest

I am trying to use multiple spreadsheets to create a pivot table in order to
analyse corporate profitablility. I am relatively new to pivot tables and can
find little help in this area.

I have a spreadsheet with a number of tabs, with a reconciliation page that
currently uses arrays and lookup to access the data from a couple of the
other tabs. I think a pivot table would work better. any ideas?

Thanks,

-Ian
 
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 single worksheet, or in a database,
and you'll have more flexibility in creating the pivot table.
 
You must log in or register to reply here.

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

Question on the occupied field of the pivot table in excel spreadsheet 0
Refreshing Pivot Table on a protected spreadsheet tab 1
pivot table space question 1
Vlookup with Pivot Table 1
Automatically Refresh pivot table 6
Pivot tables disappearing! 2
re-using pivot table layout 1
Pivot Tables Question with Excel 2000 2

Back
Top