Forum Discussion
Auto Apply Filter Functionality
Why doesn't the Windows version of Excel include 'auto-apply' functionality when selecting date to filter (Excel for Mac does)?
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.
I know I don't know anything (Socrates)
- Thanks for the reply - will take a look and let you know.
