View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 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