Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 set a row or column to not recalculate | Excel Worksheet Functions | |||
Can I force my UD Functions to recalculate? | Excel Programming | |||
How to force user function to recalculate | Excel Programming | |||
How to force all of the cells in a worksheet to recalculate? | Excel Programming | |||
VBA: Force wait until recalculate | Excel Programming |