65

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.

0
82

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.

5
  • 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
  • 3
    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
  • How to calc selection?
    – mathtick
    Jul 22 '20 at 10:44
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...

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

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