Sep 30 2022 06:58 AM
Oct 01 2022 02:09 AM - edited Oct 01 2022 02:10 AM
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)