I’m using Excel 2021, and I’ve noticed that when I hide a worksheet, Excel doesn’t update the formulas. I have formulas that depend on the number of hidden worksheets, and I need them to update automatically. How can I ensure that Excel updates these formulas when worksheets are hidden or unhidden?
I have already tried to make the functions volatile but it has no effect.
New contributor
Mario Galindo Ballivián is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.