Does Excel Can still process record that above it limits

**johnsonlim026** · 01-23-2011, 01:58 AM

Hi,
I have an excel file that is about 267337 rows to be processed.I need to do an add in for this in order to filter out the unnecessary rows which certainly produce a result in about 10k of rows.
My question is does Excel able to process 267337 rows of records before it achieve a result of only 10k rows?

Help Please !!

**johnjohns** · 01-23-2011, 04:02 AM

Sorry Johnson. I did not get this fully. Excel 2007+ versions support 1 million rows per sheet. And to work with 267337 rows of data, I fear any process would go slow.

rgds

johnjohns

**johnsonlim026** · 01-26-2011, 11:53 PM

Hi johnjohns's,
I should use Microsoft Excel 2007 instead of 2003 to process the data.
Thanks for suggestion to use Excel 2007 .
You have help me a lot !!