Results 1 to 6 of 6

Thread: Maximum rows in Excel 2010

  1. #1
    Join Date
    Dec 2009
    Posts
    54

    Maximum rows in Excel 2010

    I am having dell inspiron laptop installed with the windows 7 operating system. Also i have upgraded my office program from office 2007 to office 2010. I only need to know whether the maximum number of row that are present in the excel 2010 . Is there any one who know this can help me Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Maximum rows in Excel 2010

    As far as the ms Excel is concerned i think that the number of rows have not been changed yet. If you want to increase the number of rows of the ms excel 2010. Then i have heard that some add in is available which can increase the number of rows & columns to infinite. Hope this will help you .

  3. #3
    Join Date
    Dec 2009
    Posts
    54

    Re: Maximum rows in Excel 2010

    Thanks for replying me but i would like to know why this is not possible in the excel 2010 also i would like to know whether there is any possible option which will help me to achieve this functionality. Also if possible can you please help me to achieve this expansion in the number of rows. Thanks again

  4. #4
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Maximum rows in Excel 2010

    This all depends on what you are actually working with because if you are working with the external data then you can use PowerPivot in the ms Excel 2010 this is an addin which will help you to exceed 1,048, 576 rows but your row limit will be only upto 2 GB in terms of memory capacity or size.

  5. #5
    Join Date
    Sep 2005
    Posts
    1,306

    Re: Maximum rows in Excel 2010

    I think you can achieve this by storing the data in the MS Access program and then you can try to return the ggregated results in Excel in a pivot table return aggregated portions of data to Excel using MS Query return aggregated portions of data to Excel using ADO or VBA. Hope this will help you.

  6. #6
    Join Date
    Apr 2008
    Posts
    4,089

    Re: Maximum rows in Excel 2010

    It is quiet hard to answer this query because if you are working with the Externeal data then you can simply try to make use of the pivot table which is replaced powerpivot in excel 2010 you will have to use this addin. This will definitely increase the number of rows in excel but this too has some limit.

Similar Threads

  1. How to normalize Excel data in Excel Rows
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 06:20 PM
  2. Is it possible to have rows above 65,000 in Excel 2007
    By Nyota in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 05:07 PM
  3. Replies: 2
    Last Post: 09-07-2009, 08:57 AM
  4. How to delete bottom rows in excel
    By Dhanajay in forum Windows Software
    Replies: 2
    Last Post: 25-06-2009, 12:22 PM
  5. Delete rows in Excel [VB]
    By Janet J in forum Software Development
    Replies: 2
    Last Post: 03-02-2009, 06:31 PM

Posting Permissions

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