I am working on a spreadsheet that was developed by someone else. There are
several data columns followed by 12 monthly columns containing numerical data
for each month of the current year. In the cell in the row immediately above
the heading of each monthly col is a formula using the SUBTOTAL function to
sum each monthly col. Using the regular autofilter feature, the data
columns are filtered by expense code, project number, etc. When the
autofilters are activated, the subtotals refresh with no problem. I was
asked to make their spreadsheet filter data using multiple criteria in one of
the fields, so I set up an advanced filter for them. The data filters
correctly, but the subtotals do not refresh. I have to double click on each
individual SUBTOTAL cell to get it to refresh. Any ideas?
Thanks