On Wed, 6 May 2009 22:36:01 +0100, "Charles Williams"
wrote:

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

The website says it has been tested on 97 to 2003. Any reason to think
it might have problems on 2007?

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)?