65535 rows in Excel

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Can I import data to Excel with more than 65536 rows? Can
I split a delimited file after Excel warns the whole file
was not loaded?
 
Bill

No but there are several alternatives. XL is using MSQuery for this. You
could use different criteria on the records. For example, one query with 'up
to date x' and another with 'from date x'.

If you are summarising this data, look to use a pivot table. (Data>Pivot
table and pivot chart report). This allows you to bring in almost any
quantity of data so long as it is summarised in less than 65536x256

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top