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

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