multiple pivot data ranges
 

I once saw on here a tutorial link which, I think, showed how to circumvent
the problem of exceeding Excel sheet size when you are trying to make a pivot
of a TON of data (without Excel's standard version, which basically lumps
things into pages or something like that). Anyone have a clue of what I'm
talking about? In other words, I am getting something in the order of 25
columns and ~100k rows of data. I want a pivot which will treat all of that
as one set of data, and give me full flexibility for use in a pivot. I don't
really want to go to Crystal Reports for this, since that's just a nightmare
when compared to the ease of pivot.

Thx for any help/links.
--
Boris