69

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.

Improve this question
0

2 Answers 2

Reset to default
88

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.

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .