Community archive

Ask something
Discussion Locked

Excel 65536 row limitation.

0 helpful
5 replies

by mcastria

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Our customer actually works with Excel 2000 and need more than 65536 rows.
As it's well know, Excel only support 65536 rows.
Does any body know how to increase this limitation?
Is there any other product to be used with Excel to increase this row limit?
Best regards.

5 replies

by dklippert

That's the limit, even in Excel 2002.
The solution is clumsy in Excel (multiple worksheets).
I would suggest moving that quanity of data into Access. You can still use Excel as a front end, pointed at the Access database, with Pivot tables etc., but Access is really the answer.

by md_hashim

If there is no option to use Access, using worksheets is the only way out. Filters etc. will have to be Macro-ized to use across spreadsheets.

This discussion is closed to new replies.