Excel 2003: VLOOKUP not refreshing
 

I have a workshet that draws source data from an access database. When I
select the part number it is suppose to pull part related information into
adjoining cells on the row where the part number is selected.

For some reason Excel is not refreshing the VLOOKUP formula to display the
other part data. Can someone tell me why a VLOOKUP formula would not refresh?

Excel 2003: VLOOKUP not refreshing
 

Tools Options Calculation Automatic


"watermt" wrote:

I have a workshet that draws source data from an access database. When I
select the part number it is suppose to pull part related information into
adjoining cells on the row where the part number is selected.

For some reason Excel is not refreshing the VLOOKUP formula to display the
other part data. Can someone tell me why a VLOOKUP formula would not refresh?

Excel 2003: VLOOKUP not refreshing
 

Boy do I feel stupid, that did the trick! Thank you so much!

"Teethless mama" wrote:

Tools Options Calculation Automatic


"watermt" wrote:

I have a workshet that draws source data from an access database. When I
select the part number it is suppose to pull part related information into
adjoining cells on the row where the part number is selected.

For some reason Excel is not refreshing the VLOOKUP formula to display the
other part data. Can someone tell me why a VLOOKUP formula would not refresh?

Excel 2003: VLOOKUP not refreshing
 

You're Welcome!


"watermt" wrote:

Boy do I feel stupid, that did the trick! Thank you so much!

"Teethless mama" wrote:

Tools Options Calculation Automatic


"watermt" wrote:

I have a workshet that draws source data from an access database. When I
select the part number it is suppose to pull part related information into
adjoining cells on the row where the part number is selected.

For some reason Excel is not refreshing the VLOOKUP formula to display the
other part data. Can someone tell me why a VLOOKUP formula would not refresh?