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’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 a worksheet with the “tab” name of “Rpt_Group”. I also renamed its code name to shData. When I use VBA to activate the worksheet using “Rpt_Group” it runs fine. But when I use the code name I get an error message