[AccessD] OT- Max Row Number in Excel

Thanks, William.

Saludos
Ralf Lister


-----Mensaje original-----
De: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] En nombre de William Benson
(VBACreations.Com)
Enviado el: Domingo, 24 de Julio de 2011 08:50 p.m.
Para: 'Access Developers discussion and problem solving'
Asunto: Re: [AccessD] OT- Max Row Number in Excel

Excel 2003 had 65536. Excel 2007 and 2010 both allow 1,048,576. If you have
opened a Excel 2007 file and see only 65,536 rows you are probably in
compatibility mode, which you can turn off in the File Options (Under Save
... if you have default File Save format as .xls, then you will always be
seeing 65,536 rows in a new workbook. Change that to .xlsx).



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ralf Lister
Sent: Sunday, July 24, 2011 4:48 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] OT- Max Row Number in Excel

Hello all,

The max. row number of Excel 2007 is 65000 and something.

Does Excel 2010 allow more rows?

Saludos
Ralf Lister



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1518/3786 - Release Date: 07/24/11