61
22
I have a sheet that contains many formulas. But they do not recalculate automatically when I change input.
I'm looking for a hotkey, that can re-calculate the sheet. According to this page, F9 calculates all sheets in all open workbooks, and Shift + F9 calculates the active sheet. Neither works for me. I know a tip: delete any row to refresh sheet. But my file is too long, and I'm not comfortable with this method.
Davuz
Posted 2012-07-13T07:27:12.693
Reputation: 727
79
This often happens with very large and complex spreadsheets. Here are some workarounds you could try:
CTRL + ALT + SHIFT + F9 to recheck all formula dependencies and then recalculate all formulas.
Select any blank cell, press F2 and then Enter.
Re-enter = :
==This may take a while depending on the size of your workbook. Save your file before attempting.
Ellesa
Posted 2012-07-13T07:27:12.693
Reputation: 9 729
1
From the settings, there is a part where you can ask excel to automatically update them once you have a new input. You don't need to press any hotkey...
Fatih Karadag
Posted 2012-07-13T07:27:12.693
Reputation: 11
2OP states that this functionality isn't working and he needs a way to manually re-calculate things. – DanteTheEgregore – 2013-10-05T05:28:12.637
2I only have 3 usable fingers at the moment. What is the menu alternative to Ctrl+Alt+Shift+F9? – cprcrack – 2015-06-08T12:32:06.167
doesn't seem to be one but you can substitute AltGr for Ctrl+Alt , or use the onscreen keyboard to highlight multiple toggle keys – Some_Guy – 2017-01-09T11:22:53.440
4first time I've seen an emacs key chord on windows!! – lornix – 2012-07-14T20:49:12.453
3I prefer the replace
=by=^^ So simple and stay the same for all version of the Office – Nam G VU – 2012-07-15T12:39:11.627