Problem with external data source showing all rows Excel 2007

Hi!

I've created a external data source to an SQL Server 2005 from Excel 2007. If I try to filter to show all the rows of his year (quite a lot, many rows for each day) it can only show me data to May!?

For an entire year it should be app. 77,000 rows of data. Since it only display data to May it would mean app. half.. 38,500 rows.

Is there a setting or is it a limit in Excel 2007 when using an external data source? How can solve this? I want to see all the rows for the entire year...

Thanks!
/N

Has anyone encountered this issue before??

Does anyone know of a limit to the number of rows visible when display data from external data source?? Or a setting somewhere??

Please advise!