vlookup doesn't update / recalculate

[Guest]

I have a cell containing a VLookup that doesn't contain the correct value
If I click on the cell and then click to edit the function and push enter it
updates to show the correct value.
How can I get a macro to force the cells to update so they show the correct
value?

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a cell containing a VLookup that doesn't contain the correct value
| If I click on the cell and then click to edit the function and push enter it
| updates to show the correct value.
| How can I get a macro to force the cells to update so they show the correct
| value?

 

[Guest]

Your calculation mode may be set to manual. Go to
Tools--Options--Calculation and select Automatic.

Then your formulas should update automatically.

Dave

 

[Guest]

I forgot to say the vlookup is looking at an external reference.

If I push ctrl alt F9 that should recalculate everything right? That
doesn't update the cells, only when you go and click to try and edit the
formula in the cell then push return does it update.

 

[Niek Otten]

It should recalculate, unless you have a construct where Excel can't find the precedents. If you supply your formula, we could
check.
Sometimes (very, very rarely) Excel loses track of precedents. You can rebuild the dependency tree by pressing CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I forgot to say the vlookup is looking at an external reference.
|
| If I push ctrl alt F9 that should recalculate everything right? That
| doesn't update the cells, only when you go and click to try and edit the
| formula in the cell then push return does it update.
|
| "Niek Otten" wrote:
|
| > Look here:
| >
| > http://xldynamic.com/source/xld.xlFAQ0024.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a cell containing a VLookup that doesn't contain the correct value
| > | If I click on the cell and then click to edit the function and push enter it
| > | updates to show the correct value.
| > | How can I get a macro to force the cells to update so they show the correct
| > | value?
| >
| >
| >

 

[Guest]

VLOOKUP(S15,'\\pk1srv1\BeGroupData\HR\Succession\PMIS Download\[Latest PMIS
Download.xls]Sheet1'!$A$4:$C$10000,3,0)

I've tried CTRL ALT SHIFT F9 and that doesn't work either

 

[Guest]

Is the file PMIS Download still stored in the directory path specified?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

VLOOKUP(S15,'\\pk1srv1\BeGroupData\HR\Succession\PMIS Download\[Latest PMIS
Download.xls]Sheet1'!$A$4:$C$10000,3,0)

I've tried CTRL ALT SHIFT F9 and that doesn't work either

It should recalculate, unless you have a construct where Excel can't find the precedents. If you supply your formula, we could
check.
Sometimes (very, very rarely) Excel loses track of precedents. You can rebuild the dependency tree by pressing CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I forgot to say the vlookup is looking at an external reference.
|
| If I push ctrl alt F9 that should recalculate everything right? That
| doesn't update the cells, only when you go and click to try and edit the
| formula in the cell then push return does it update.
|
| "Niek Otten" wrote:
|
| > Look here:
| >
| > http://xldynamic.com/source/xld.xlFAQ0024.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a cell containing a VLookup that doesn't contain the correct value
| > | If I click on the cell and then click to edit the function and push enter it
| > | updates to show the correct value.
| > | How can I get a macro to force the cells to update so they show the correct
| > | value?
| >
| >
| >

 

[Guest]

Yep, the file is there, the sheet is named that, the lookup value is correct.

The cell will show the correct value if i go into the formula bar and push
return. The cell then updates to show the correct value. I just dont'
understand why it won't update any other way

I've got a whole column of this stuff so I can't do that for every cell.

Is the file PMIS Download still stored in the directory path specified?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

VLOOKUP(S15,'\\pk1srv1\BeGroupData\HR\Succession\PMIS Download\[Latest PMIS
Download.xls]Sheet1'!$A$4:$C$10000,3,0)

I've tried CTRL ALT SHIFT F9 and that doesn't work either

It should recalculate, unless you have a construct where Excel can't find the precedents. If you supply your formula, we could
check.
Sometimes (very, very rarely) Excel loses track of precedents. You can rebuild the dependency tree by pressing CTRL+ALT+SHIFT+F9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I forgot to say the vlookup is looking at an external reference.
|
| If I push ctrl alt F9 that should recalculate everything right? That
| doesn't update the cells, only when you go and click to try and edit the
| formula in the cell then push return does it update.
|
| "Niek Otten" wrote:
|
| > Look here:
| >
| > http://xldynamic.com/source/xld.xlFAQ0024.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I have a cell containing a VLookup that doesn't contain the correct value
| > | If I click on the cell and then click to edit the function and push enter it
| > | updates to show the correct value.
| > | How can I get a macro to force the cells to update so they show the correct
| > | value?
| >
| >
| >