Auto Apply Filter Functionality

Brass Contributor

Why doesn't the Windows version of Excel include 'auto-apply' functionality when selecting date to filter (Excel for Mac does)? 

2 Replies



Welcome to your Excel discussion space!

for your Information


About the issue:

Untested, I'm not sure if it works with Excel for web... The proof of the pudding is in the eating :)).

If it is Excel for web, a possible solution would be to clear the filter before saving the file. The easiest way to do this is with VBA (you would have to use a subscription version in advance to insert the code into the workbook): In the ThisWorkbook code module:





In das Codemodul "DieseArbeitsmappe":

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)


End Sub






Hope I was able to help you with this information.



I know I don't know anything (Socrates)

Thanks for the reply - will take a look and let you know.