Limit rows of linked excel table

[FJM]

I have a report which runs from a linked excel worksheet. Is there any way I can limit the number of rows in the access reports to only show those rows which are populated in the excel worksheet.
Presently, if the excel worksheet has information in say 20 rows, when I come to print the access report it is telling me there are 1067 records and the only way I can print is by selecting pages 1 & 2 of the report to print
Thanks for any help

[JoeM]

One way to get around this is to create a query from your table, and pick some field (column in Excel) which is always populated, and add Criteria under that field that says "Not Is Null". That will get rid of all your blank rows. Then use the query instead of the table as the Control Source of your Report.