Refresh Filtering

[debbyrr7]

I am trying to refresh my filters after I updated some data and that option is grayed out. Is there a preference in Excel Options that I need to change?
Thanks,
Deb

 

[pbornemeier]

Welcome to the board.
If you have an autofilter in place and you edit some of the visible data, you can reapply the filter by clicking on the auto filter arrow at the top of the column(s) that you edited and re-select the desired criteria.

 

[debbyrr7]

Phil, Thanks. I figured it out yesteday afternoon.

Deb

 

[schielrn]

If you are using 2007, you can click on the filter drop down and then just press OK again.

Hope that helps.

 

[debbyrr7]

Thanks!

 

[Colin Legg]

In Excel 2007, you can also click on the "reapply filter" button on the ribbon and it will refresh all of the autofilter's filters.

 

[debbyrr7]

Colin, the reapply button is the one that was originally grayed out. I even tried several worksheets and it was grayed out in any senario/any sheet. That's why I was wondering if there was a preference that needed changing. I ended up completely shutting down my computer and when I re-opened it the ability to use the reapply button returned. Thanks.
Deb

 

[schielrn]

In Excel 2007, you can also click on the "reapply filter" button on the ribbon and it will refresh all of the autofilter's filters.

Never noticed that button beofre and it beats hitting the drop down and pressing ok again, which works 99% of the time though.

Thanks for that Colin.

 

[Colin Legg]

Colin, the reapply button is the one that was originally grayed out. I even tried several worksheets and it was grayed out in any senario/any sheet. That's why I was wondering if there was a preference that needed changing. I ended up completely shutting down my computer and when I re-opened it the ability to use the reapply button returned. Thanks.
Deb

Hi Deb,

Ah okay, that clears up the issue you were facing - sorry for the crossed-wires. The reapply button will only become enabled if the autofilter is in filtermode: that is, one of it's filters is actually filtering data. Was that the problem?

Never noticed that button beofre and it beats hitting the drop down and pressing ok again, which works 99% of the time though.

Thanks for that Colin.

< rant >
<RANT>
Funnily enough I was doing some VBA research on the 'new' 2007 Autofilter features the other week. In the interface the Ribbon button's caption is 'reapply', but in the VBA Excel Object Model the equivalent autofilter object method is 'ApplyFilter'. Why on earth did they call it that!? Why not 'Reapply' to make it consistent with the UI, or even 'ReapplyFilters'? I got really excited for a moment because I thought a new way of applying filtering criteria to the filter objects had been introduced (which would have been very useful!). Ah well....
< /rant ></RANT>