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, 2022 in Database by Edureka
• 13,630 points
160 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, 2022 by gaurav
• 22,940 points

Related Questions In Database

0 votes
1 answer

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

The BIT datatype can be used to ...READ MORE

answered Sep 15, 2022 in Database by narikkadan
• 52,400 points
432 views
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, 2022 in Database by Edureka
• 13,630 points
158 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, 2022 in Database by Edureka
• 13,630 points
148 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

answered Sep 12, 2022 in Database by narikkadan
• 52,400 points
346 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

There is no LIKE & IN combination ...READ MORE

answered Sep 18, 2022 in Database by narikkadan
• 52,400 points
136 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
508 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
424 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
504 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, 2022 in Database by gaurav
• 22,940 points
79 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, 2022 in Database by gaurav
• 22,940 points
195 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP