| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell wont calculate automaticaly!
After running a long macro a cell containing this formula: "=SI(C148=0;0;Interest_Rate(H16*12;C150;(C68+C101) ))" (SI is IF in french excel) wont calculate automaticaly anymore! I tried adding "Calculate" at th end of the Macro and pressing "F9" for recalculation of the whol workbook and neither worked. I have to go in the formula field an press enter manualy for the cell to recalculate. Anyone have an idea?? thanks in advance -- krhym ----------------------------------------------------------------------- krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522 View this thread: http://www.excelforum.com/showthread.php?threadid=38713 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel wont calculate | Excel Discussion (Misc queries) | |||
| wont calculate | Excel Discussion (Misc queries) | |||
| goal seek wont calculate an accurate value past 3 decimal places | Excel Discussion (Misc queries) | |||
| Cell does not calculate automaticaly | Excel Discussion (Misc queries) | |||
| refresh a cell automaticaly each second ? | Excel Programming | |||
Threaded Mode
