Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE
My spread sheet, before I had this trouble, computed all the cells that
contained formulas to show the values. Along the way I must have done something that caused all of the cells to only show formulas. I have tried everything, but they sill only show formulas. Even with a simple reference to another cell such as: F8 referenced to cell B6 that contains a number such as 25, still shows F8 or, F20 contains a calculation such as F9(3)*C8(5) =15, F20 shows F9*C8. If I a trace, the trace work and points to the precedents making up the answer. I think there must be a setting that I can't find in EXCEL07. I am new to 07 and am still not up to speed with the screwed up ribbon at the top of the page. I have used EXCEL03 for years, am no longer EXCEL literate. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrolling differences b/w Excel 97-2003 and new Excel07 | Charts and Charting in Excel | |||
EXCEL07 how to use text in a PivotTable value field | Excel Discussion (Misc queries) | |||
Formulas cut and paste but do not compute | Excel Worksheet Functions | |||
formulas will not compute | Excel Worksheet Functions | |||
Formulas that don't compute | Excel Worksheet Functions |