Hello,

When mentioning calculating cells, do you mean
1.Call a AddIn function and set the returned value to the range.Value, or
2.The cell's Range.Value2 is set to an UDF expression which is implemented
in another Addin?

Generally, we can call the Range.Calculate method to update the UDF value,
http://msdn.microsoft.com/en-us/libr...op.excel.range
.calculate(office.11).aspx


Best regards,
Ji Zhou
Microsoft Online Community Support