How can I see more than 65,536 rows in Excel 2007?

T

TraceyGMEC

Everytime I open Excel 2007 I only see 65,536 rows and before I have everyone
on my team upgrade to Excel 2007 I need to make sure that it can go up to 1
million rows. Do I have to install an add-in to get the extra lines?
 
D

Dave Peterson

This happens when you start a new workbook?

If yes, then I bet you have a template file (*.xlt) that was saved as an xl2003
(or below) file.

Try deleting (or moving) that book.xlt file (use Windows|Search to find it)
 
T

TraceyGMEC

That worked! My IT group changed the option to save it as Excel 2003 since
most of the company is still on Office 2003. Once I removed that option I now
see over a million lines. THANK YOU!!!!!
 

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

Adding more than 65,536 rows in Excel 2007 5
Excel 2007 - million rows 2
Excel 2007 # of rows 7
Number of rows in Excel 2007 worksheets 3
Copy text with more than 65,536 lines into Excel 9
Excel 2007 with no increase in rows and columns 2
Additional Rows and Columns in Excel 2007 1
Number of rows in Excel 2007 2

Top