Why is there still a row limit in Microsoft Excel

0 votes
Until Office 2007, Excel has a maximum of 65,000 rows. Office 2007 bumped that up to a max of 1 million rows, which is nicer of course; but I'm curious -- why is there a limit at all? Obviously, performance will slow down exponetially as you increase the spreadsheet size; but it shouldn't be very hard to have Excel optimize for that by starting with a small sheet and dynamically "re-sizing" it only as needed. Given how much work it must have been to increase the limit from 65K to 1 million, why didn't they go all the way so it's limited only by the amount of available memory and disk space?
Mar 28 in Database by Edureka
• 9,320 points
24 views

1 answer to this question.

0 votes
Because of optimizations, most likely. There are a total of 16 384 columns and 1 048 576 rows in Excel 2007. Weird figures? 20 bits = 1 048 576, 14 bits = 16 384
More than one 32-bit register can hold when 14 + 20 = 34 bits are added together.
However, they must also save the cell's format (text, number, etc.) and formatting (colors, borders etc). They use 34 bits for the cell number and 30 bits for other items if they use two 32-bit words (64 bit). What is the significance of this? They don't need to allocate all of the memory required for the entire spreadsheet in memory; instead, they just need to allocate the memory required for your data, and each piece of data is tagged with the cell it should be in.
answered Mar 30 by Edureka
• 8,820 points

Related Questions In Database

0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30 in Database by Edureka
• 9,320 points
12 views
0 votes
0 answers

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
12 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
313 views
0 votes
1 answer

Is there any boolean type in Oracle database?

Nope. I don't think there is one But ...READ MORE

answered Oct 10, 2018 in Database by Neha
• 6,300 points
272 views
0 votes
1 answer

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,240 points
349 views
0 votes
2 answers

How to select the nth row in a SQL database table?

SELECT * FROM ( SELECT ID, NAME, ROW_NUMBER() ...READ MORE

answered Apr 23, 2020 in Database by anand
• 140 points
15,486 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 9,320 points
30 views
0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15 in Database by Edureka
• 8,820 points
27 views
0 votes
1 answer

is there a shortcut to open filter>contains box in excel?

The shortcut for opening the filter drop-down ...READ MORE

answered Apr 11 in Database by Edureka
• 8,820 points
25 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
37 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP