Exceed Row Limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear experts,

I've a data file which currently storing 64850 records. As the row limit of
a worksheet is 65536 rows, how can I continue to store my reocrds with an
existing growth of 300+ rows/week? I don't want to open another worksheet as
the master worksheet is linked with another file which uses to extract
records from the master worksheet. Is there any ways to extend the row limit
or better method to store my records. Please advise.

Thanks a million.
 
There is *no way* to extend the number of rows beyond 65,536. If you don't
want to start using another worksheet then your options are limited. Excel
2007 has over 1 million rows per worksheet. Maybe a database program would
better suited for what you're doing.
 
Thanks

T. Valko said:
There is *no way* to extend the number of rows beyond 65,536. If you don't
want to start using another worksheet then your options are limited. Excel
2007 has over 1 million rows per worksheet. Maybe a database program would
better suited for what you're doing.
 
Back
Top