Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 21st 08, 03:45 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2
Default How can I see more than 65,536 rows in Excel 2007?

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?

  #2   Report Post  
Old January 21st 08, 05:36 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default How can I see more than 65,536 rows in Excel 2007?

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)


TraceyGMEC wrote:

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?


--

Dave Peterson
  #3   Report Post  
Old January 21st 08, 05:52 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2
Default How can I see more than 65,536 rows in Excel 2007?

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!!!!!

"Dave Peterson" wrote:

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)


TraceyGMEC wrote:

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?


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding more than 65,536 rows in Excel 2007 WL Excel Discussion (Misc queries) 5 December 23rd 09 01:45 PM
Excel 2007 - million rows maureen Excel Discussion (Misc queries) 2 November 29th 07 08:39 PM
how can I shade alternate rows in Excel 2007? lingo123 Excel Discussion (Misc queries) 3 November 25th 07 10:50 PM
Excel 2007 rows & columns Jim[_3_] Excel Discussion (Misc queries) 3 July 1st 07 04:28 AM
How do I view the maximum rows in Excel 2007 (Million Rows)? shanth Excel Discussion (Misc queries) 2 January 15th 07 05:45 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017