Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why do I have to enter the cell (F2) for cell to calculate?
I have an extensive workbook that does not always calculate when I hit F9. I
often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order for cell to calculate. This is very cumbersome when there are thousands of cells that contain formulas. |
#2
|
|||
|
|||
first try alt/shift/F9 (full recalculate)
If that doesn't do it, select one cell, then use Edit/Replace, and replace = with =. This has the effect of reentering each formula. Bob Umlas Excel MVP "TJ" wrote in message ... I have an extensive workbook that does not always calculate when I hit F9. I often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order for cell to calculate. This is very cumbersome when there are thousands of cells that contain formulas. |
#3
|
|||
|
|||
Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9
-- Kind regards, Niek Otten Microsoft MVP - Excel "TJ" wrote in message ... I have an extensive workbook that does not always calculate when I hit F9. I often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order for cell to calculate. This is very cumbersome when there are thousands of cells that contain formulas. |
#4
|
|||
|
|||
Thank you. Your solution worked.
"Niek Otten" wrote: Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9 -- Kind regards, Niek Otten Microsoft MVP - Excel "TJ" wrote in message ... I have an extensive workbook that does not always calculate when I hit F9. I often have to enter each cell by hitting F2, theb Ctrl+Shft+Entr in order for cell to calculate. This is very cumbersome when there are thousands of cells that contain formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
How do I format a cell in MS Excel to enable me to enter a mobile. | Excel Discussion (Misc queries) | |||
enter value in a cell from a combo box | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |