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

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

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

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

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.


On Aug 11, 5:17*pm, "Peo Sjoblom" wrote:
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 withF9(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