Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple pivot 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple pivot data ranges | Excel Discussion (Misc queries) | |||
Pivot Table: Mult Consolidation Ranges | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Pivot Table-Using Multiple SS's or Ranges? | Excel Discussion (Misc queries) |