Check for "regular" filters removing rows... I spent hours looking for a programmatic solution, then an issue with excel, before finally realizing that a filter 30 columns in was blocking rows...