how do I get more than 65000 rows to display in Excel 2007

[Guest]

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

 

[Bernie Deitrick]

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

 

[Guest]

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.

 

[Dave Peterson]

Did you close that workbook and reopen it?

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]

If the file was from an earlier version, you need to open it, save it as the .xlsx, then close it
and re-open it to get the extra rows.

HTH,
Bernie
MS Excel MVP

 

[Guest]

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