Do you have a workaround workflow in the meantime? I could imagine a few non-Macro or Macro-light solutions to this. Use a pivot table for example, the results of which I believe get 'magiced' into their destination cells instead of getting hidden, I however don't recall whether they auto-inherit autofilters set on the source table and/or source cell range.

How much organizational (not technical, we'll get to that) control/authority/input/stakeholder role do you have on the source document templates?

Also, you might want to check out https://github.com/microsoft/advanced-formula-environment/

> Do you have a workaround workflow in the meantime?

Yeah in the VisiData ticket I link to a post[1] with some code to handle hidden rows and columns in Pandas+openpyxl.

[1] https://towardsdatascience.com/how-to-load-excel-files-with-...