Take the 2-minute tour ×
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 14 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
1  
first time I've seen an emacs key chord on windows!! –  lornix Jul 14 '12 at 20:49
1  
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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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