Is there a way to force Excel 2007 to recalculate just one cell?
 

As I read the help,

F9 Calculates all worksheets in all open workbooks.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks,
regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all
cells in all open workbooks, including cells not marked as needing to
be calculated.

CTRL+F9 minimizes a workbook window to an icon.

Is there some way to force Excel to recalculate just one cell without
recalculating anything else?

I have a sheet that calls a VBA function from a lot of different
cells. If I put a trace or msgbox in the function for debugging, I
don't want it to run 50 times.

Is there a way to force Excel 2007 to recalculate just one cell?
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Prof Wonmug" wrote in message
...
As I read the help,

F9 Calculates all worksheets in all open workbooks.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks,
regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all
cells in all open workbooks, including cells not marked as needing to
be calculated.

CTRL+F9 minimizes a workbook window to an icon.

Is there some way to force Excel to recalculate just one cell without
recalculating anything else?

I have a sheet that calls a VBA function from a lot of different
cells. If I put a trace or msgbox in the function for debugging, I
don't want it to run 50 times.

Is there a way to force Excel 2007 to recalculate just one cell?
 

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

Is there a way to force Excel 2007 to recalculate just one cell?
 

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

Is there a way to force Excel 2007 to recalculate just one cell?
 

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

Is there a way to force Excel 2007 to recalculate just one cell?
 

On Wed, 6 May 2009 23:10:38 +0200, "Niek Otten"
wrote:

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

Is there a way to set a keyboard shortcut to toggle this setting
between automatic and manual? It doesn't appear that one already
exists.

Is there a way to force Excel 2007 to recalculate just one cell?
 

On Wed, 6 May 2009 23:10:38 +0200, "Niek Otten"
wrote:

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

This workaround is OK if it's a single cell, but there is apparently
no way to recalculate a range of cells all at once without
recalculating the whole worksheet.

This is inconsistent behavior. Excel allows me to do all sorts of
things to the the selected cells.

It's too bad, because Alt-F9 is available and could be used for just
this purpose.

Looks like a design bug.

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