Currently functionality is Jet automatically removes autofilters across the whole application.

There are some reports where AutoFilters breaks Jet (replicating rows) and some where it does not (static reports like financial statements).

Would like to propose a new keyword for cell A1 like +AutoFilters where we can turn on/off the autofilters by workbook/worksheet.

Gives a little more control to the report writer, and reduces user frustration.

If you REALLY wanted to take this to the next level, I would request that +AutoFilters does the following:

• Instead of removing the autofilter all together I would have it simply clear the filter if it is active (similar to the VBA function worksheet.ShowAllData), that way the autofilter remains as the designer has set them, it is just clears before Jet begins working.