excel filter not working on new rows

Ill select a value and it will filter the data onto that value correctly - except for row 400 and beyond. To give more detail I h…