A certain xlsx file I work on refreshes (recalcc to cells) only when I save in Office 2010.
How come? How can I change it?
Excel will refresh when you press F9
Alternatively you could have a macro running that refreshed on a given time.
You can also check in Options - Formulas - Calculation Options to ensure that automatic calculations is turned on.