M
Max
Excel has so much to offer, but it limits the number of records...any chance
of increasing the number?
of increasing the number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JulieD
there is no way to expand the number of rows in the current versions ....
however, if you'ld like to let MS know what you think send them an email at
[email protected]
with excel in the subject line and your request / ideas / suggestions in the
message body.
however, if you'ld like to let MS know what you think send them an email at
[email protected]
with excel in the subject line and your request / ideas / suggestions in the
message body.
M
Michael
Hi Max
Simple answwer is NO.
However, you could break your data up across a number of sheets and then
bring your totals back together on a summary sheet.
OR
You could look at using a database.
HTH
Michael
Simple answwer is NO.
However, you could break your data up across a number of sheets and then
bring your totals back together on a summary sheet.
OR
You could look at using a database.
HTH
Michael
X
X_HOBBES
I feel your pain. I too sometimes wish I could exceed this limit. Michael
has it right -- break it up into multiple worksheets if you must use Excel,
or use a small database. I recommend Access as a next step -- it's a
lightweight database with a great deal of functionality, but it lacks the
on-the-fly data analyzing and massaging capabilities that Excel is so
wonderful at.
Good luck!
BTW... Excel can get very slow once it gets up in size and has a bunch of
formulas.
X_HOBBES
has it right -- break it up into multiple worksheets if you must use Excel,
or use a small database. I recommend Access as a next step -- it's a
lightweight database with a great deal of functionality, but it lacks the
on-the-fly data analyzing and massaging capabilities that Excel is so
wonderful at.
Good luck!
BTW... Excel can get very slow once it gets up in size and has a bunch of
formulas.
X_HOBBES
B
Bill Sharpe
One spreadsheet alternative is Quattro Pro, which lets you set up to
1,000,000 rows and about 18,000 columns. I think with that many records
you're better off with a database -- FileMaker Pro is easier to learn
than Access.
Bill
Excel has so much to offer, but it limits the number of records...any
chance
of increasing the number?
1,000,000 rows and about 18,000 columns. I think with that many records
you're better off with a database -- FileMaker Pro is easier to learn
than Access.
Bill
Excel has so much to offer, but it limits the number of records...any
chance
of increasing the number?
F
Fredrik Wahlgren
Max said:Excel has so much to offer, but it limits the number of records...any chance
of increasing the number?
No
If you need so many records, perhaps you should use something like MSDE,
VistaDB or Access.
/Fredrik
B
Bulent Alev
Hi,
I agree with the performance problem. However we should be able to increase
the number of lines. it is almost 8 year since it was increased to 65,536.
Any idea how to do it in Excel and not alternative program.
Regards,
Bulent
I agree with the performance problem. However we should be able to increase
the number of lines. it is almost 8 year since it was increased to 65,536.
Any idea how to do it in Excel and not alternative program.
Regards,
Bulent