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

[Prof Wonmug]

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.

 

[Niek Otten]

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

 

[Prof Wonmug]

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

 

[Charles Williams]

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


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

 

[Prof Wonmug]

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?

 

[Prof Wonmug]

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.

 

[Prof Wonmug]

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.

 

[Charles Williams]

It works fine in Excel 2007

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