| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Calculation
CTRL+ALT+F9 (equivalent to CalculateFull)
-- Kind regards, Niek Otten Microsoft MVP - Excel "ben" wrote in message ups.com... | Hi | I'm importing a recordset from Access where one of the column is | displaying a reference to a named range. | Then I se "=" + [Namedrange name] in Excel. I force to recalculate | (calculate method on the range or on the workbook) but doesn't refresh | the value neither. I have to select the cell , Press F2 to get the | actual value. Anyway to force recalculation ? | Note : I have to work on MAnual Calc mode | | | Thanks for your help | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| force a $0.00 | Excel Discussion (Misc queries) | |||
| Force Tab | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| Cell doesn't do calculation until you force it. | Excel Programming | |||
| range.calculation with UDF not working when calculation is set to automatic | Excel Programming | |||
Threaded Mode
