W wintay99 Feb 21, 2009 #1 My data has more than 65K rows but when I open Excel 2007, only show me 65K rows someone help to show all Thanks
My data has more than 65K rows but when I open Excel 2007, only show me 65K rows someone help to show all Thanks
F FARAZ QURESHI Feb 21, 2009 #2 File must be in old version *.xls Resave the file in 2007 version. Close it. & Reopen the same.
B Bill Sharpe Feb 22, 2009 #3 FARAZ said: File must be in old version *.xls Resave the file in 2007 version. Close it. & Reopen the same. Click to expand... 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
FARAZ said: File must be in old version *.xls Resave the file in 2007 version. Close it. & Reopen the same. Click to expand... 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