How to breakthrough row number limitation

B

Billy Leung

Hi all,

The default row number limitation for each sheet is 65,536. Is it possible
to increase it up to 100,000 ? Your help would be appreciated.


Billy
 
J

JE McGimpsey

No. You'll have to use multiple columns or multiple worksheets (or
another app, like Quattro Pro or Access).
 
B

Billy Leung

Hi JE McGimpsey, thank you so much for your prompt response.

My situation is -- I need to import a dbf file which the record is more than
65,536. How should I do to make it?

Billy
 
H

Harlan Grove

Billy Leung wrote...
....
My situation is -- I need to import a dbf file which the
record is more than 65,536. How should I do to make it?
Click to expand...

Is this DBF file sorted? If so, you could use multiple queries against
it to pull in all records into multiple worksheets.
 
Top