Press F9 - Calculates formulas that have changed since the last calculation and formulas in all open workbooks.
Press SHIFT+F9 - Calculates formulas that have changed since the last calculation and formulas dependent on them in the active worksheet.
Press CTRL+ALT+F9 - Calculates all formulas in all open workbooks since last changed.
Press SHIFT+ALT+F9 - Rechecks dependent formulas and then calculates all formulas in all open workbooks since last changed.
By default it should be auto re-calculating.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment