Thanks Dave,
I've re-opened and can now see the full (1mill+) no of rows.
Roger

"Dave Peterson" wrote:

Did you close that workbook and reopen it?

Excel 2007 maximu rows wrote:

Thanks Bernie,
I've tried saving as an Excel Workbook (i.e. Excel 2007 with .xlsx extension
) and I still only have 65536 rows available.

"Bernie Deitrick" wrote:

I think that it's controlled by the 'Save files in this format' setting in the Save tab of
the Excel Options dialog box.

HTH,
Bernie
MS Excel MVP


"Excel 2007 maximu rows" <Excel 2007 maximu wrote in message
...
I have just recently installed Office 2007 and expected over 1 milliion rows
to be displayed in Excel.

For whatever reason, only 65536 rows are being displayed




--

Dave Peterson