Increasing Excel Row Limitation 65K

general discussion
1

Hi All,

Is there any way we can increase the Excel row limitation from 65K (65536) rows to bigger number.

Thanks,
Vijay

vijaykollu :us: (BOB member since 2003-05-08)

2

No, you will have to find some workaround…

Excerpt from MS Excel docs


Feature                           Maximum limit 
Open workbooks                    Limited by available memory and system resources 
Worksheet size                    65,536 rows by 256 columns 
Column width                      255 characters 
Row height                        409 points 
Page breaks                       1000 horizontal and vertical 
Length of cell contents (text)    32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. 
Sheets in a workbook              Limited by available memory (default is 3 sheets) 
Colors in a workbook              56 
...............

This is the status of current version of office (2003 a.k.a 11)
Beta of next version of Office (Office 12) has nearly the same limitations.

shamit (BOB member since 2004-07-01)

3

Hi,

The work around is, Save the file as .txt/csv then open it using Ultraedit tool.

You can download this tool for free at http://www.ultraedit.com/downloads

Thanks,
Vijay

vijaykollu :us: (BOB member since 2003-05-08)