| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
| What is Ctrl + Shift + Enter ? | Excel Discussion (Misc queries) | |||
| shift option ctrl etc | Excel Discussion (Misc queries) | |||
| Shift-Ctrl-DownArrow | Excel Discussion (Misc queries) | |||
| Ctrl+Shift+arrow | Excel Worksheet Functions | |||
Hybrid Mode
