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

Dealing with a Pivot Table (when I don't want to) 0
Increasing number of rows beyond 65K 3
How to I expand the number of rows beyond 65536? 2
New computer, how do i move outlook 365 ENTIRELY? 0
Excel 2007 # of rows 7
Excel 2007 XML export seems limited by row count 0
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
ADOBE Connection to open Excel workbook 3

Top