Forum Discussion
How to get Excel to automatically re-apply a filter when my table changes?
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
I use on ordinary filter (not a table filter) on just one column. So the VBA may be fairly simple. However, I'm not clear what activates the filter. I want it to be activated whenever data in that column is updated. I don't really understand how your VBA works.
One other thing, I have always shy-ed away from VBA macros as they are a security risk which will put off most users.
I use excel 2019 on Windows 10 and would dearly love to be to put it online to the public - but I haven't figured how to do this yet.
I would gladly send you my workbook but it is difficult to understand without the accompanying research paper, which I have yet to write. It's an improvement on the standard https://en.wikipedia.org/wiki/Kermack%E2%80%93McKendrick_theory SIR model, to make it spatial-and-temporal-sensitive, based on the results of my ABM-modeling.
Ian
Perhaps more simple variant as here How To Automatically Reapply Auto-Filter When Data Changes In Excel? works in your case.
SergeiBaklan Is there away to make this work if it is the result of a formula which changes rather than manually changing the cell data?
That's quite old post. These date perhaps it's better to use FILTER function - Microsoft Support
Thank you so much for this. Can I make it work in more than 1 tab per file? Or in all of them?
Terrific Sergei. You are a star. Does exactly what I wanted.
I have a question though. I have always shied away from using VBA macros as they seem to be a security risk and other users of my workbook will be put off from accessing it. Is that a problem with this as well?
Many, many thanks, Ian
Ian, you are welcome.
In this case that's quite simple code which you enter yourselves, thus that's safe. However, if you share workbook, other people could refuse to work with macro-enabled workbook. In organization ITS could test the workbook and give okay to use it. Or ITS won't to waste time testing each macro users bring, in such case they simply prohibit to use any macro. Or ITS trusts to protecting software installed within organization, they have regular backups of everything and allow users to use practically everything.
Approximately the same with individuals. I don't know how to prove them this or that macro-enabled file is safe. Security is always in conflict with usability, the only question is how to find the compromise.
Sergei, once again, many thanks for your response which I read with great interest.
Unfortunately, it confirmed my fears. My situation is that I am lone researcher developing a new mathematical model of virus transmission which I plan to publish. In my research paper I hope to provide a link to a public online version of my spreadsheet so that readers can see live plots of the transmission dynamics according to the parameters they select, which would require the filter to be re-applied. However, readers will not open a spreadsheet that is flagged as a security risk. Please can you suggest a method of doing this that would avoid it being a security risk. Frankly, I cannot see how an online spreadsheet can be a security risk but I admit to being very ignorant about online spreadsheets.
