Forum Discussion

Brandi Nelson's avatar
Brandi Nelson
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's avatar
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's avatar
    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.

Resources