Refresh VLookup Data

Copper Contributor

Hello,

The first time I enter the Vlookup information, it will retrieve the correct information (in terms of correct row and column), after I change the Cell value, it will not refresh. It just stays stuck on the previous value (row/col combination).  

 

I need to update the data in one worksheet with the data in the original sheet without having to double click and press enter in each cell.

 

B-

2 Replies

Dear Brandi Nelson,

If Calculation option has been set as manual in the file, then change it to automatic.

Formulas > Calculation Options > Automatic

 

If the Vlookup function is refering to the data in the a different file, then confirm that the other file is open.

 

If possible share the formula, data and the result.

 

Do let me know if this solves your problem.

 

Vijaykumar Shetye,

Spreadsheet excellence,

Panaji, Goa, India

Hello,

 

I am having issues to get the updates on the VLOOKUP formula from one file to another.

The formula is only updated if I retype the formula or if I re-open the file.

The VLOOKUP formula in my file which links to another excel file (both of them are on my one drive) is:

=VLOOKUP(I7,'https://gimoltd-my.sharepoint.com/[...]/[Sprint management.xlsx]Sheet1'!$D$7:$I$9,6)

 

NB: I used the "[...]" to make it cleaner here in this issue reporting.