Hi all,

I've got a spreadsheet that has a named range and is hidden. Sometimes it won't auto update unless you click into the cell which contains the formula

The Auto calc is on so can't understand why it won't update. Happens with all users of the spreadsheet

Any tips of advise welcome

VBA Noob