Auto Apply Filter Functionality

Copper Contributor

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

2 Replies

 

@KevinM1981 

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)

  ActiveSheet.ShowAllData

End Sub

 

 

 

 

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

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