View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Is there a way to force Excel 2007 to recalculate just one cell?

It works fine in Excel 2007

"Prof Wonmug" wrote in message
...
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)?