Thread: I can only import 65,536 rows in Excel? I thought 2007 handled 1M
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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?


Reply With QuoteReply With Quote