Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Maximum rows in Excel 2010

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 18-02-2010
Member
 
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.

Reply With Quote
  #2  
Old 18-02-2010
Member
 
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 .
Reply With Quote
  #3  
Old 18-02-2010
Member
 
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
Reply With Quote
  #4  
Old 18-02-2010
Member
 
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.
Reply With Quote
  #5  
Old 18-02-2010
Member
 
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.
Reply With Quote
  #6  
Old 18-02-2010
Member
 
Join Date: Apr 2008
Posts: 4,086
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.
__________________
Ram requirement for various OS
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Maximum rows in Excel 2010"
Thread Thread Starter Forum Replies Last Post
How to normalize Excel data in Excel Rows Hache hi MS Office Support 2 24-02-2012 07:20 PM
Is it possible to have rows above 65,000 in Excel 2007 Nyota MS Office Support 2 21-02-2012 06:07 PM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 09:57 AM
How to delete bottom rows in excel Dhanajay Windows Software 2 25-06-2009 01:22 PM
Delete rows in Excel [VB] Janet J Software Development 2 03-02-2009 07:31 PM


All times are GMT +5.5. The time now is 03:05 AM.