View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harry Harry is offline
external usenet poster
 
Posts: 71
Default 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