62

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.

80

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 = :

    • Select cells that contain formulas you'd like to update
    • Press CTRL+H.
    • Find what: =
    • Replace with: =

    This may take a while depending on the size of your workbook. Save your file before attempting.

  • 4
    first time I've seen an emacs key chord on windows!! – lornix Jul 14 '12 at 20:49
  • 3
    I prefer the replace = by = ^^ So simple and stay the same for all version of the Office – Nam G VU Jul 15 '12 at 12:39
  • 2
    I only have 3 usable fingers at the moment. What is the menu alternative to Ctrl+Alt+Shift+F9? – cprcrack Jun 8 '15 at 12:32
  • 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 Jan 9 '17 at 11:22
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...

  • 2
    OP states that this functionality isn't working and he needs a way to manually re-calculate things. – DanteTheEgregore Oct 5 '13 at 5:28

Not the answer you're looking for?Browse other questions tagged or ask your own question.