Unless my old .xls file was renamed to the new 2007 extensions (.xlsm or
..xlsx), my old .xls function formulas did not work (even though 1 million
rows displays).

Perhaps it is the same issue with you?
--
Thx
MSweetG222



"barnabel" wrote:

Is there some place to set the maximum number of rows returned by a query?
One of the resons I upgraded to Excel 2007 was the row limit increase. but I
just ran a query and the data cut off at row 65536. I know there should be
about another 20K rows.

Peter Richardson