Sep 30 2022 06:58 AM
Why doesn't the Windows version of Excel include 'auto-apply' functionality when selecting date to filter (Excel for Mac does)?
Oct 01 2022 02:09 AM - edited Oct 01 2022 02:10 AM
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)
Oct 03 2022 07:57 AM