AutoFilter Question

Hey folks, I am trying to use the Filter/Autofilter function in Excel 2007. I can do so for on column/set of values, but when I try to set multiple filters on different columns it won't let me. Well it will, but as soon as I try to add a second filter it erases the changes of the first; I can not apply more than one filter at once.

I know for sure I could do this in Excel 2003. **** I hate this new office suite . **** I hate Microsoft. If I can't figure this **** out I'm installing OpenOffice, lol.

I've attached the xls file if anyone has a moment to peek at it. For instance, when I try to apply a filter to the "Status" column, then try to add an additional one to the "Custodian" column, it erases the changes to the "Status" column and ultimately doesn't allow me to apply multiple filters (which I could do in Excel 2003).

Tia For Any Help/Advice,

M35514H