Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I have more than 65K rows when I open Excel 2007

My data has more than 65K rows but when I open Excel 2007, only show
me 65K rows
someone help to show all
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default I have more than 65K rows when I open Excel 2007

File must be in old version *.xls
Resave the file in 2007 version.
Close it.
&
Reopen the same.
--

Best Regards,
FARAZ A. QURESHI


" wrote:

My data has more than 65K rows but when I open Excel 2007, only show
me 65K rows
someone help to show all
Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 348
Default I have more than 65K rows when I open Excel 2007

FARAZ QURESHI wrote:
File must be in old version *.xls
Resave the file in 2007 version.
Close it.
&
Reopen the same.


I don't think that's going to bring back the missing rows. However, If
you add rows in 2007 version and then save as .xlsx file the extra rows
that you just added should appear.

Bill
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
Open UTF-8 in Excel 2007 simplex Excel Discussion (Misc queries) 2 April 18th 10 07:31 PM
Excel 2007 won't open normally. PhillyRon Excel Discussion (Misc queries) 1 January 20th 09 09:12 PM
slow to open Excel 2007 and Word 2007 (MIS stumped) JoAnn Excel Discussion (Misc queries) 0 December 11th 08 03:07 PM
Help open Excel 2007 excelyn New Users to Excel 2 November 16th 08 05:26 PM
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 09:25 PM.

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

About Us

"It's about Microsoft Excel"