View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Muhammed Rafeek M Muhammed Rafeek M is offline
external usenet poster
 
Posts: 179
Default Exceed Row Limit

you have to upgrade to Excel 2007 (Row limit is 1048576)

"Freshman" wrote:

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.