Hi Sean

it sounds as though you started from an xls file, which would have been
loaded in compatibility mode.
Save the file as an xlsx 2007 fileCloseRe-open
and you should be able to access all 1 million+rows

--
Regards
Roger Govier

"Sean" wrote in message
...
I can only get 65,356 rows when I link Excel to an external data source. I
am
using an ODBC driver to link to an IBM i-series database (AS400). The
database has 167,000+ rows. I thought Excel 2007 had a row limit of 1mil+.
Is
there different limit for linked tables?