View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
teh_chucksta teh_chucksta is offline
external usenet poster
 
Posts: 14
Default subtotals with custom autofiltering

Hi, and thanks for helping,

I have a large data set, with lots of subtotals. When I customize an
autofilter for a particular column (say Weeks on Hand <=4), the subtotal
automatically reverts to level 3. When I reset to level 2, the customized
autofilter no longer works, and I get all values. What to do?

Thanks again,
Charlie