If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table with source spread across multiple worksheets
All...
I've got a very large data set carrying details across several worksheets... Ideally, I'd like to be able to perform a single Pivot Table looking at all of the worksheet data within Excel and all of the capabilties of the Pivot Table object... I've worked around my initial issue by importing the data into an Access database and using the Excel Pivot Table Object, an extra step that I'd like to avoid... I've found that attempting to consolidate multiple ranges does not provide all of the capabilities of a "standard one source" Pivot Table, am I missing something during the range consolidation step -- Joe Mac |
#2
|
|||
|
|||
Pivot Table with source spread across multiple worksheets
Check He
Look for a file named 'PT0007 - Multiple Consolidation Ranges' I prefer this method: Create a summary worksheet from all worksheets in in your workbook: http://www.rondebruin.nl/summary.htm Than, build your Pivot Table off of this source!! Regards, Ryan--- -- RyGuy "Joe Mac" wrote: All... I've got a very large data set carrying details across several worksheets... Ideally, I'd like to be able to perform a single Pivot Table looking at all of the worksheet data within Excel and all of the capabilties of the Pivot Table object... I've worked around my initial issue by importing the data into an Access database and using the Excel Pivot Table Object, an extra step that I'd like to avoid... I've found that attempting to consolidate multiple ranges does not provide all of the capabilities of a "standard one source" Pivot Table, am I missing something during the range consolidation step -- Joe Mac |
Thread Tools | |
Display Modes | |
|
|