2.1.246 Section 8.7, Filters

  • Article

a.   This is not supported in core Word 2007.

b.   This is supported in core Excel 2007.

  1. If the filter is applied to a query table, Excel 2007 will lose the filter if the query table is refreshed.

  2. Only top/bottom filters are supported if the filter is on a pivot table with external data.

  3. If any of the filters specified on a range or data pilot isn't fully supported, Excel 2007 will not load the filter for that range or data pilot.

  4. These are some of the cases that cause a filter to be dropped on load, this is not a comprehensive list:

    OR statements nested within an AND statement.

    The top 10 filters within an OR statement (the top 10 filters are the only things that can be applied to a column).

    If the number of filters for a particular column > 2 and all signs are not a series of "OR equals X", that is, not a "list of possible values" scenario.

    If one column has more than one filter criteria within a single OR statement.

    If a single column has criteria in multiple AND statements and at least one of them is a Top 10 filter.

    If a single column has >2 criteria and an AND statement.

    If a column has a top 10 filter and the column type is text instead of numerical data.