Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 37 down vote accepted

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.

share|improve this answer
Thank you very much! I got that! – Davuz Jul 13 '12 at 10:22
first time I've seen an emacs key chord on windows!! – lornix Jul 14 '12 at 20:49
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
I only have 3 usable fingers at the moment. What is the menu alternative to Ctrl+Alt+Shift+F9? – cprcrack Jun 8 at 12:32

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...

share|improve this answer
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

protected by Community Jul 3 at 4:29

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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