ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   over 65500 cells? (https://www.excelbanter.com/excel-programming/340522-over-65500-cells.html)

Sweden[_4_]

over 65500 cells?
 

Hallo everybody!

Any idea if itīs possible to get more then 65500 cells out of excel or
is it impossible?

Sweden


--
Sweden
------------------------------------------------------------------------
Sweden's Profile: http://www.excelforum.com/member.php...o&userid=27322
View this thread: http://www.excelforum.com/showthread...hreadid=468911


Dave Peterson

over 65500 cells?
 
The number of rows is limited to 65536 per worksheet.



Sweden wrote:

Hallo everybody!

Any idea if itīs possible to get more then 65500 cells out of excel or
is it impossible?

Sweden

--
Sweden
------------------------------------------------------------------------
Sweden's Profile: http://www.excelforum.com/member.php...o&userid=27322
View this thread: http://www.excelforum.com/showthread...hreadid=468911


--

Dave Peterson

Jim Thomlinson[_4_]

over 65500 cells?
 
As Dave says a worksheet is 65,536 rows and that is not negotiable. However
you can link Excel up to Access and through Queries or Pivot Tables Access a
much larger number of records.
--
HTH...

Jim Thomlinson


"Sweden" wrote:


Hallo everybody!

Any idea if itÂīs possible to get more then 65500 cells out of excel or
is it impossible?

Sweden


--
Sweden
------------------------------------------------------------------------
Sweden's Profile: http://www.excelforum.com/member.php...o&userid=27322
View this thread: http://www.excelforum.com/showthread...hreadid=468911




All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com