I'm using excel 2010.
I have had a look at other "auto-update" and from what I saw they wanted you to type some information in to make it "refresh" the auto-update.
I have is two separate spread sheets and I have a table with filtered headings and I have a sheet with raw data. I have three columns on the table however I do not physically put any data into it. When the other spreadsheet is updated the references automatically place the values into my table.
For example the filter is set to "UK" but we still require to have all values there in case reference is needed as the people using this spreadsheet are not allowed to see the workings spread sheet due to confidentiality reasons.
Would make my life that little bit easier rather than un-filtering and re-filtering.