How do I get my Excel 2007 worksheet to go beyond 65536 rows?

A

Alan

I saved the workbook as a .xlsx before I even started creating a spreadsheet,
and I can't get any spreadsheet in the workbook to go beyond the old limits
of 65536. I thought 2007 automatically had row limits of over a million.
 
B

Bernard Liengme

If you open a 'classic' workbook (ie pre Excel 2007), Excel goes into
compatibility mode.
The title bar displays this info
Once you have saved the file as an XLSX file you need to close and reopen
the file to get 2007 mode
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increasing number of rows beyond 65K 3
How to I expand the number of rows beyond 65536? 4
Excel 2007 # of rows 7
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
opening text files that have more rows than 65536 3
Excel 2007 >65536 rows-convert 1
Excel 2007 Move or Copy worksheet 2
Is it possible to fill rows in Excel beyond 65536? 3

Top