Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kalz
 
Posts: n/a
Default Maximum no of rows in Excel

Dear All,

Working on a large file of data, wondering what is the max. rows in excel it
can handle? Also, the maximum rows in Pivot table?

thx,
Kalz
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Kalz

maximum rows per worksheet is 65536
and according to help the number of row fields in a pivot table is limited
by available memory

check out Excel Specifications and Limits in help

Cheers
JulieD

"kalz" wrote in message
...
Dear All,

Working on a large file of data, wondering what is the max. rows in excel
it
can handle? Also, the maximum rows in Pivot table?

thx,
Kalz



  #3   Report Post  
MikeY
 
Posts: n/a
Default

Max number of rows: 65536 for Excel 97 or newer
Max number of rows in Pivot table: Depend on the memory remained

--
Mike

"kalz" wrote in message ...
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how can you add more rows in excel 2000? Khody Excel Discussion (Misc queries) 3 February 16th 06 12:30 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 05:55 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 30th 04 12:56 AM


All times are GMT +1. The time now is 03:46 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"