| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula result not displayed
I have a large spreadsheet (28MB) that is not displaying formulas results in
one worksheet. The formulas are not complex (ex., +'Placeholders 2006 Master'!$L$80*'Placeholders 2006 Master'!AO$141). If I go to any cell and hit F2 to edit it directly that cell will display its result, even if it is referencing another cell that is experiencing the same problem. A simple F9 does nothing but I discovered by accident that Ctl ALt Shift F9 did cause the formulas to calculate. Does anyone know why this happens and how we can keep it from happening again? Thanks for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
| How do I get the formula to show the result on the worksheet? | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
