Downlaod my range.calculate addin from
http://www.decisionmodels.com/downloads.htm#RngCalc


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Prof Wonmug" wrote in message
...
On Wed, 6 May 2009 23:10:38 +0200, "Niek Otten"
wrote:

Set Calculation to Manual. Select the cell and press F2, ENTER.

That works. It's a pain.

Is there no other way to tell Excel to recalculate just one cell
without having to change an option (and then remember to change it
back)?