I ran out of rows

[Guest]

As you all know, there are 65,536 rows available in
excel. I frequently have data sets that exceed this limit
and am wondering if anyone knows if there is an add-in or
anything that is available to extend the number of rows
available??

 

[Ron de Bruin]

Not possible, use Access or split it up in more sheets

 

[Frank Kabel]

Hi
sorry to say but there is no way to overcome this restriction (besides
using another spreadsheet product or maybe even better a database).
So the only way for you is to divide the data on two (or more)
worksheets
Frank