difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with
Have you tried to add NOW() to the formula
=add-in+(NOW()*0)
--
Regards,
Peo Sjoblom
"Harry" wrote in message
...
We have add-ins that sometimes require refreshing the data using the
parameters provided in the cells.
We have found that forcing Excel to recalculate with F9 (or
Alt-Shift-Ctrl-F9) will not force the formulas to recalculate.
However, using the Control-H (Replace = with = ) method works just fine.
Every cell is recalculated.
Is there any reason for this? Workbook settings are on automatic
calculations.
thanks,
Harry
|