Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hidden result
hello,
in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if a conditional formatting should be applied to the cell. Thanks, Emiliano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hidden result
Try reformatting the cell as General (or anything but text).
Then re-enter the formula (Select the cell, Hit F2, then Enter should do it). And if the formula doesn't recalc, make sure you have calculation set to automatic. (Tools|Options|Calculation tab) It kind of sounds like you have both situations. eggpap wrote: hello, in one complex Excel 2003 application some formulas stopped to show their results. Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10)) the formula remains written instead of disappearing and formatted like if a conditional formatting should be applied to the cell. Thanks, Emiliano -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions |