Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calc now (F9) doesn't work
Hi
What might be the problem, when cell values with formulas are not updated, even if i press F9 (or have the calculation functionality set to "automatic") ? I only can recalculate the cell, when i go to the end of the formula and just press <Return again - without changing anything in the formula. Thanks for any hints Elis |
#2
|
|||
|
|||
Hi Elis,
I sometimes have the same problem, can't seem to find a remedy for it but try this. Highlight the whole page and click Edit Replace and then replace the '=' sign with the '=' sign. I know this sounds odd but it seems to kick start excel into working and is the only way I can solve the problem. "elis" wrote: Hi What might be the problem, when cell values with formulas are not updated, even if i press F9 (or have the calculation functionality set to "automatic") ? I only can recalculate the cell, when i go to the end of the formula and just press <Return again - without changing anything in the formula. Thanks for any hints Elis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
Service work order | Charts and Charting in Excel | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Lookup Doesn't Work | Excel Worksheet Functions |