buffer size

[ovince]

hi All

Is it posible to load large files (more than ~65000 rows) in Excel? Where to adjust if the answer is yes?

Thank you
Oliver

[Bryan Hessey]

hi All

Is it posible to load large files (more than ~65000 rows) in Excel? Where to adjust if the answer is yes?

Thank you
Oliver

you need to split the file into two parts, and use two worksheets.

hth
---

[Dav]

The previous answer is true, unless you buy excel 2007, It has lots more rows, although I can not remember how many but it is over 1000000

Regards

Dav

[Bryan Hessey]

The previous answer is true, unless you buy excel 2007, It has lots more rows, although I can not remember how many but it is over 1000000

Regards

Dav

1M (2^20) according to http://visio.mvps.org/Excel_2007.htm with 16k (2^14) columns.


But I guess that extra specification doesn't help the OP today, hopefully Notepad was able to split the file, alothough I fancy that there is some code somewhere to switch sheets during an input of data lines.

---