Cell only updates when I go into formula bar

[Silloway2Sample]

I have a vlook-up formula looking up values in column E. The cell with the
v-lookup cell has #n/a in it until I click into the cell in column E, then
click in the formula bar and press enter. Once I do that then the v-lookup
cell updates with the correct information? Is there a way to update the
entire column E so that I don't have to go into each and every cell for my
v-lookup to work?

[bgeier]

Check your Calculation settings
Tools -> Options -> Calculation check "Automatic"

[Silloway2Sample]

Automatic is already checked.

"bgeier" wrote:

>
> Check your Calculation settings
> Tools -> Options -> Calculation check "Automatic"
>
>
> --
> bgeier
> ------------------------------------------------------------------------
> bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
> View this thread: http://www.excelforum.com/showthread...hreadid=547580
>
>