Force Calculation

B

ben

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
 
N

Niek Otten

CTRL+ALT+F9 (equivalent to CalculateFull)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Calculation 5
Force Recalc 3
force recalculation of function 5
Automatic Calculation in Code Takes Longer than Worksheet 3
VBA UDF Calculation (not) 4
Prolem with recalculation 6
VBA: Force wait until recalculate 3
How to control recalculation in VBA? 1

Top