Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.links,microsoft.public.excel.programming
|
|||
|
|||
Modifying the cell dependies
I have a function F() implemented in an XLL, which depends on cell C.
Even though it calls Excel4(xlCoerce) on that cell, Excel doesn't seem to add the cell to the dependency graph. As a result, changes to cell C don't cause Excel to recalculate cells which call F(). Is there any way to force Excel to reevaluate the cell when C changes, which is compatible with Excel 2000? Thanks, Aaron Queenan. |
#2
Posted to microsoft.public.excel.interopoledde,microsoft.public.excel.links,microsoft.public.excel.programming
|
|||
|
|||
Modifying the cell dependies
Excel only knows to recalculate functions when one of their input arguments
change or is recalculated, or the function is volatile. So either change F() to F(C) or make the function volatile (add ! as the last character in the type_text argument). (see page 224 in the MS Excel Devlopers Kit) hth Charles ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "Aaron Queenan" wrote in message ... I have a function F() implemented in an XLL, which depends on cell C. Even though it calls Excel4(xlCoerce) on that cell, Excel doesn't seem to add the cell to the dependency graph. As a result, changes to cell C don't cause Excel to recalculate cells which call F(). Is there any way to force Excel to reevaluate the cell when C changes, which is compatible with Excel 2000? Thanks, Aaron Queenan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
modifying name format within a cell | Excel Discussion (Misc queries) | |||
Copying information from one cell to another without modifying it. | New Users to Excel | |||
Modifying cell references | Excel Discussion (Misc queries) | |||
Modifying Cell Addresses and operating on them | Excel Worksheet Functions | |||
Modifying cell entries? | New Users to Excel |