View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freshman Freshman is offline
external usenet poster
 
Posts: 158
Default Exceed Row Limit

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.