ExcelBanter - truncation with imports via html

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - truncation with imports via html (https://www.excelbanter.com/excel-worksheet-functions/203658-truncation-imports-via-html.html)

jvblue

truncation with imports via html

I am trying import HTML into excell, but if i choose to import the file it
will truncate the excell with 65533 rows.
However if i save the html as .txt and import the file into excell then i
get 100,00+ rows. Why is it that html and excell are not allowing the full
import of the file?

ie 7
office 2007

All times are GMT +1. The time now is 08:19 AM.