Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BorisS
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple pivot data ranges BorisS Excel Discussion (Misc queries) 0 September 15th 05 06:13 AM
Pivot Table: Mult Consolidation Ranges MRT Excel Discussion (Misc queries) 2 July 12th 05 04:20 AM
Pivot Table - Multiple consolidation Range tengreen Excel Worksheet Functions 1 July 1st 05 07:18 PM
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222 Excel Worksheet Functions 0 February 22nd 05 04:55 PM
Pivot Table-Using Multiple SS's or Ranges? Jugglertwo Excel Discussion (Misc queries) 2 February 5th 05 04:25 AM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"