Excel 2007 : Default filter in shared workbook please??

Hi all,

Can anyone please help?

I have set up a shared spreadsheet requiring input from many users. I have put in an autofilter to allow users to quickly select their relevant lines for quick entry, although not all use this.

The trouble is if a user does this and leaves the filter on when they save and exit, another user (unfamiliar with filters) will come in and see many lines missing and get stuck!

Other than providing some basic excel training (!) does anybody know if I can set the default formatting (in terms of having an open filter) so that each users changes are saved but the sheet will always open with an unchecked filter?

Any help much appreciated. Thanks for all the other useful advice in the forums that have saved me hours/days/lifetimes!

Many thanks

Matt