Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Roby36
 
Posts: n/a
Default Add more than 65536 rows?

Hello, I need to add more than 65536 in a excel worksheet, Do you know
it it is possible?

Many Thanks
Ricy

  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

No, no possible. You'll have to use a second sheet, and a third if necessary.

Alternatively, use Microsoft Access.


"Roby36" wrote:

Hello, I need to add more than 65536 in a excel worksheet, Do you know
it it is possible?

Many Thanks
Ricy


  #3   Report Post  
Roby36
 
Posts: n/a
Default

Thank you for your answer, I read that it is possible to use pivot
table, to select only the row you need, is it true? And How Can I do?

Bye

  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Roby

For instructions on Pivot Tables see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

Scroll down to the "P" section.


Gord Dibben Excel MVP

On 29 Aug 2005 14:35:23 -0700, "Roby36" wrote:

Thank you for your answer, I read that it is possible to use pivot
table, to select only the row you need, is it true? And How Can I do?

Bye


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
opening text files that have more rows than 65536 rondajoy Excel Worksheet Functions 3 June 8th 05 03:41 PM
how can i increase number of rows beyone 65536 in excel sheet increasing number of rows in excel sheet Excel Discussion (Misc queries) 2 April 28th 05 07:03 AM
Excel should accomodate more number of rows than 65536, to load l. Laxman Charipally Excel Discussion (Misc queries) 1 April 22nd 05 09:41 PM
Can I increase row capacity beyond 65536 rows Trish Excel Worksheet Functions 2 February 23rd 05 11:15 PM
increasing the number of rows of a worksheet beyond 65536? ibu Excel Discussion (Misc queries) 2 November 26th 04 08:56 AM


All times are GMT +1. The time now is 07:35 AM.

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"