Cell only updates when I go into formula bar

  • Thread starter Silloway2Sample
  • Start date
S

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

bgeier

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