What is the largest file size, I can Import to excel?

G

Goran

I have tryed to import a txt file (about 50MB) into excel and I recived
error message. Something about 65000 lines or so....

Any idea?

thanx
/goran
 
C

Chip Pearson

Goran,

The maximum number of rows on a worksheet is 65,536 so you can't
import more than that many records without writing code to work
with multiple worksheets.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top