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.
Sub turnoff() 'Turn Off calculation and start call ontime routine Application.Calculation = xlCalculationManual Call DoTimer End Sub Sub DoTimer() 'Call the sheet calculation macro every one second Application.OnTime Now + TimeValue("00:00:01"), "Rep" End Sub
Sub Rep() ' calculate the sheet and repeat the ontime process
You can also check in Options - Formulas - Calculation Options to ensure that automatic calculations is turned on.