Filter in Excel 2013

Hi,

In excel 2013 I applied a "filter" so that you can eliminate certain things & then saved the file..........over the weekend my spreadsheets sheet 1 updated but sheet 2 didnt. So, the filter didn't update/ hold its criteria, I had to go in and reapply filter.

Is there a way for the filter to auto update?

Sheet 1 has data, Sheet 2 is just linked to sheet 1 with a filter for 1 particular person
when data is added to sheet 1, its doesn't auto update in sheet 2.

Thx

PS. Shg had suggested (view->custom view) but that isn't working