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.

--
Biff
Microsoft Excel MVP


"Freshman" wrote in message
...
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.