Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 15th 07, 05:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2
Default How do I view the maximum rows in Excel 2007 (Million Rows)?

When I open a new file in Excel 2007, I can see only 65536 Rows, instead of
1048576 rows. How can see the maximum rows and columns in Excel 2007.

  #2   Report Post  
Old January 15th 07, 05:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 301
Default How do I view the maximum rows in Excel 2007 (Million Rows)?

If you're opening a file last saved in 2003, it will open in "compatibility
mode" which displays the same limits as xl2003. You need to convert it to
the current format. Use Office Button/Convert. Note that this will delete
the original. You'll then have all the cells.
Bob Umlas
Excel MVP

"shanth" wrote in message
...
When I open a new file in Excel 2007, I can see only 65536 Rows, instead
of
1048576 rows. How can see the maximum rows and columns in Excel 2007.



  #3   Report Post  
Old January 15th 07, 05:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 2
Default How do I view the maximum rows in Excel 2007 (Million Rows)?

Thank you Bob, it worked.

"Bob Umlas" wrote:

If you're opening a file last saved in 2003, it will open in "compatibility
mode" which displays the same limits as xl2003. You need to convert it to
the current format. Use Office Button/Convert. Note that this will delete
the original. You'll then have all the cells.
Bob Umlas
Excel MVP

"shanth" wrote in message
...
When I open a new file in Excel 2007, I can see only 65536 Rows, instead
of
1048576 rows. How can see the maximum rows and columns in Excel 2007.






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
The increase number of rows in Excel wise_man Excel Discussion (Misc queries) 12 January 17th 07 02:38 PM
Excel 2003 Workbook I want to convert to Excel 2007 pglufkin Excel Discussion (Misc queries) 3 December 18th 06 07:06 PM
Where did my Publish to Excel Services go? Mike L Setting up and Configuration of Excel 8 December 7th 06 10:46 AM
Excel 2007 Nick Hodge Excel Discussion (Misc queries) 0 July 5th 06 08:49 PM
print area selection slows excel, formula for hiding rows?? sbrimley Excel Discussion (Misc queries) 1 March 21st 06 11:26 PM


All times are GMT +1. The time now is 02:39 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017