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

  • Thread starter Thread starter Harry
  • Start date Start date
H

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
 
Have you tried to add NOW() to the formula


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



--


Regards,


Peo Sjoblom
 
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.
 
Back
Top