Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot Table - Multiple Worksheets | Excel Discussion (Misc queries) | |||
Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |