Forum Discussion

Copper Contributor

May 12, 2017

Refresh VLookup Data

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 stay...

Excel Desktop

Formulas & Functions

vijaykumar shetye

Brass Contributor

May 13, 2017

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

Deleted

Mar 08, 2019

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.