0

I'm using Excel 365 and I have Calculation Options set to Manual. As far as I know the Ctrl+Shift+Alt+F9 shortcut is supposed to recalculate all cells in the entire workbook, even if some of them don't need to be recalculated (or something like that). Most of the time it works fine but recently I found one spreadsheet where this shortcut will not always recalculate cells: it will freeze the computer for a few secs meaning it is performing some work but when it finishes most (or all?) cells seem to be untouched. I don't know whether it doesn't recalculate any of them or just some of them. It also seems to be random when this shortcut does and does not seem to work (sometimes it works just fine).

Generally, are there any exceptions or situations where Ctrl+Shift+Alt+F9 might not work (or stop working e.g. upon an error)? I couldn't find anything on google.

5
  • Excel 365 Recalculate All is Ctrl-Alt-F9 Have you tried that? Is your F9 key dual purpose so that F9 is something else?
    – anon
    Commented May 23, 2022 at 13:34
  • Yes, same result. (I've also just updated my question to specify Excel version.)
    – NPS
    Commented May 23, 2022 at 13:53
  • Maybe try an Office Full Repair to see if that helps. Otherwise I am not certain.
    – anon
    Commented May 23, 2022 at 13:55
  • Do you have Fn keyboard?
    – Lee
    Commented May 24, 2022 at 9:48
  • If you mean that instead of F9 the keyboard is sending another signal then that's not it. There's a chance it's something specific to my sheet and functions/stuff it uses but unfortunately I cannot post it here for you to check.
    – NPS
    Commented May 25, 2022 at 7:40

0

You must log in to answer this question.

Browse other questions tagged .