Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aleck
 
Posts: n/a
Default How do I increase the limit on the number of import rows in Excel

Hi,

Does anyone know how to increase the number of rows that Excel can import or
read? My version is XP pro. Now the limit is about 65000 rows. I have data
sheet that is much more than that. Thank you.

Aleck
  #2   Report Post  
 
Posts: n/a
Default

hi,
65536 is the max. hard coded into excel.
in xl help type specifications for more details

-----Original Message-----
Hi,

Does anyone know how to increase the number of rows that

Excel can import or
read? My version is XP pro. Now the limit is about 65000

rows. I have data
sheet that is much more than that. Thank you.

Aleck
.

  #3   Report Post  
Kassie
 
Posts: n/a
Default

You could split your data into 2 or more sheets

"Aleck" wrote:

Hi,

Does anyone know how to increase the number of rows that Excel can import or
read? My version is XP pro. Now the limit is about 65000 rows. I have data
sheet that is much more than that. Thank you.

Aleck

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
Is there a limit to the number of rows that can be filtered W Paul Excel Worksheet Functions 3 March 8th 05 04:41 AM
Increase rows in worksheet beyond 65,536 row limit Ann Calantzis Excel Discussion (Misc queries) 2 February 25th 05 02:33 PM
How do I limit the number of complete sentences in a spreadsheet c sbernard Excel Worksheet Functions 1 February 13th 05 06:26 AM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Increase the limit to number of columns? David Pharmacy 777 Excel Discussion (Misc queries) 4 December 15th 04 05:43 PM


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