Missing Rows Excel Import

[Anonymous]

I have a query that pulls in all excel files in a folder that contains a single spreadsheet of sales for every month. The average row in each on is around 55,000. Everything has been great until recently after adding the latest month sales I seem to be missing data. 

I filter the appended data set to that month I am missing almost 10,000 rows as the queiry only counts 59k but the spreadsheat actually has 68k. 

This is the first month this as happened. I have looked at the file and right at the row it cuts off and there is nothing wrong with the data, I don't recieve any warnings or issues when I refresh the data. I have tried removing two months of sheat from earlier years and refreshing to see if it was a limitation. 

Nnot sure what else to troubleshoot, any ideas would be very appreciated!!

[Yoshimitsu411]

Hello

Did you find a solution to this problem?

Thanks

[adityavighne]

1. check you have the filter applied anywhere
2. OR while pasting you did with formula