PivotTable Data Source Questoin

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

Guest

Hi, I've just built a giant pivot table that I am quite proud of (my first pivot table). It draws from one data sheet that, in turn, is linked to about 30 workbooks. I data is linked to forecasts that will change so I need to refresh my pivot table often. The source data probably contains about 17000 links... kind of clunky. I am wondering if there is a better way for a pivot table to extract information from the 30 workbooks (the 30 workbook data sheets are identically structured). I probably don't need a detailed response, just some pointers that there is a a more elegant solution. Thanks all for your past and future advice.
 
Without knowing what you are trying to do exactly, it may be possible to use the consolidation feature of pivot tables.

When you start the wizard, select "multiple consolidation ranges" and then have a play.
 
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

PivotTable auto-refresh with external data 4
Error Message when I open Workbook 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Workbook pivot table design function 6
Pivot table data source 1
Auto insert of a pivot table? 1
Can a pivot table be redirected to an external source? 1
PivotTable Sum 2 Columns 1

Back
Top