How to correct a lock-up during recalculation in F9

Entry Type: Informational

Product: F9

Application: n/a

Version Reported: n/a

Subject:
How to correct a lock-up during recalculation in F9

Possible Resolution:
Disable the Auto Recalculation for F9 and Excel.

1. F9 / Options uncheck "Always calculate functions"
2. Restart Excel for this change to take effect

If the problem persists:

Select Tools / Options / Calulation tab, check Manual