Excel 2003. I have a worksheet with a data table of sales activity with
column headings like Sales Region, Product Type, Order Type, # of Units, and
Price (plus several others that provide extra detail). In the rows above the
data table I sum the total number of units ordered, the total dollar value,
and the average price.

What I need to do is allow filtering of the data table while still allowing
the formulae/formulas to work (recalculate). The end users should be able to
select a certain product type or sales region to filter the data table, and
have the formulas re-calculate. I use pivot tables on a separate sheet for a
simple summary of the info, but on this page I want the entire set of extra
columns also included in the data table so that each record has all of the
appropriate info displayed for regional sales managers.

When using simple auto-filter drop down menus, the formulas don't
recalculate.
I used the Create List feature and it worked (filtered list based on column
selections and recalculated the subtotals) but when I emailed the file to
other people the filter arrows don't even show up.
Help.
Thanks.