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.

Oliver Salzburg
  • 89,072
  • 65
  • 269
  • 311
Davuz
  • 827
  • 1
  • 8
  • 9

2 Answers2

89

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.

Ellesa
  • 11,185
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
  • 11