PDA

View Full Version : enhance capacity


baccon
09-30-03, 11:20
Is there any way to have more than 65536 lines in a worksheet???

Any ad-in or something??

Thanks

baccon

RickKnight
09-30-03, 13:55
Nope. That's the max 65,536 rows x 256 columns. No add-ins that I've ever seen, but maybe there's a way to accomplish what you want to do but using additional sheets. What are you trying to do?

-----
Is there any way to have more than 65536 lines in a worksheet???

Any ad-in or something??

Thanks

baccon [/SIZE][/QUOTE]

baccon
10-01-03, 11:40
i need more than 65536 lines in the same worksheet, im using access already but it would be great if i could use excel because my client is an excel expert but not that good in access.


thank you and regards

baccon

RickKnight
10-01-03, 12:39
Well, you can't get more lines (rows) in one sheet. I don't know what your building, but Excel is not a database. Access is an excellent db and maybe you should be providing your client with 'feels like Excel' user interface through the forms w/table view or db reporting.
Good Luck

Originally posted by baccon
i need more than 65536 lines in the same worksheet, im using access already but it would be great if i could use excel because my client is an excel expert but not that good in access.


thank you and regards

baccon [/SIZE][/QUOTE]