difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with

[Harry]

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

 

[Peo Sjoblom]

Have you tried to add NOW() to the formula


=add-in+(NOW()*0)



--


Regards,


Peo Sjoblom

 

[DarkStarHarry]

I haven''t . I am trying to get at the root cause of the problem and I
am looking to understand the fundamental difference between the two.