Size Limitation in Excel 2000

[don]

It appears there is a size limitation in Excel 2000 of
65536 Rows but I can not find anything stating this in
writing. Can anyone tell me if this correct or can you
increase the number of rows beyond this figure? Is so can
you tell me how as I haven't been able to find where you
would do this.

 

[Anon]

It appears there is a size limitation in Excel 2000 of
65536 Rows but I can not find anything stating this in
writing. Can anyone tell me if this correct or can you
increase the number of rows beyond this figure? Is so can
you tell me how as I haven't been able to find where you
would do this.

Presumably it can be found in Help under "specifications for Microsoft
Excel", as it can in Excel97.
Anyway, 65536 is the limit for each sheet and it cannot be changed

 

[Norman Harker]

Hi Don!

Excel specifications are listed in Help for all versions although
Microsoft keep moving it around. Details for accessing specs are
below. But to get the row limit before your very eyes press and hold
down Ctrl and then press the down arrow.

No! You can't increase it. And if you delete a row, a new row 65536
gets added to the bottom.

Specification search:

Excel 2002 and Excel 2000:

Help > Microsoft Excel Help
Select Answer Wizard Tab
Type:
Excel Specifications
Search

Excel 97:

Help > Contents and Index
Select Index Tab
Type:
Excel
Double Click "specifications"

The location of Excel Specifications varies according to Excel Version

"Installing and Removing Excel" Excel 2002
"Getting Started" Excel 2000

But Excel 97? There just doesn't appear to be an entry in the Contents
tab at all so you have to search the Index.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.