ExcelBanter - I have more than 65K rows when I open Excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I have more than 65K rows when I open Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/221818-i-have-more-than-65k-rows-when-i-open-excel-2007-a.html)

[email protected]

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

FARAZ QURESHI

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

Bill Sharpe

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

All times are GMT +1. The time now is 08:34 PM.