Results 1 to 9 of 9

Thread: More than 1,048,576 rows

  1. #1

    More than 1,048,576 rows



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    Quick question. Is it possible to get more than 1,048,576 rows in excel? I need about 1,600,000 rows. If yes, how?

    Thanks in advance


    // Esben Ploug

  2. #2
    Multiple sheets.

  3. #3
    Thanks

    But will multiple sheets work in one pivot? All 1,6 mill rows should be working in the same pivot.

  4. #4
    Yes, if you use the old pivot wizard(Alt-D-P), there is an option for multiple consolidation ranges in there.

  5. #5
    Thank you so much i'll try it

  6. #6
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    You can also use Microsoft Query (which is built into Excel) to create a PivotTable without that Multiple Consolidation method. Or you can use a macro to do the same. Check out http://www.contextures.com/xlPivot08.html

    And if you've got Excel 2010 - or Excel 2013 Professional - then you can use something called PowerPivot. Give google a spin for more info.

  7. #7
    Thank you JeffreyWeir

  8. #8
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).

  9. #9
    Seeker Salam's Avatar
    Join Date
    Nov 2012
    Location
    GTA
    Posts
    7
    Articles
    0
    Quote Originally Posted by WizzardOfOz View Post
    If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).
    2010 excel version has more than what you are looking for...

    Salam

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •