ExcelBanter - I can only import 65,536 rows in Excel? I thought 2007 handled 1M

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

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

- - I can only import 65,536 rows in Excel? I thought 2007 handled 1M (https://www.excelbanter.com/excel-discussion-misc-queries/173446-i-can-only-import-65-536-rows-excel-i-thought-2007-handled-1m.html)

hdesoto

I can only import 65,536 rows in Excel? I thought 2007 handled 1M

I thought Excel 2007 had 1 Million row capacity. but I can only import 65K.
Does anyone know why the difference?

Bernard Liengme

I can only import 65,536 rows in Excel? I thought 2007 handled 1M

Sounds like you imported an XLS file (previous version of Excel)
Try making an XLSX file
Office Button | Convert and follow the clues
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"hdesoto" wrote in message
...
I thought Excel 2007 had 1 Million row capacity. but I can only import
65K.
Does anyone know why the difference?

All times are GMT +1. The time now is 04:01 PM.