Home

Refresh VLookup Data

%3CLINGO-SUB%20id%3D%22lingo-sub-69606%22%20slang%3D%22en-US%22%3ERefresh%20VLookup%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20first%20time%20I%20enter%20the%20Vlookup%20information%2C%20it%20will%20retrieve%20the%20correct%20information%20(in%20terms%20of%20correct%20row%20and%20column)%2C%20after%20I%20change%20the%20Cell%20value%2C%20it%20will%20not%20refresh.%20It%20just%20stays%20stuck%20on%20the%20previous%20value%20(row%2Fcol%20combination).%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20need%20to%20update%20the%20data%20in%20one%20worksheet%20with%20the%20data%20in%20the%20original%20sheet%20without%20having%20to%20double%20click%20and%20press%20enter%20in%20each%20cell.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EB-%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-69606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363406%22%20slang%3D%22en-US%22%3ERe%3A%20Refresh%20VLookup%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363406%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20issues%20to%20get%20the%20updates%20on%20the%20VLOOKUP%20formula%20from%20one%20file%20to%20another.%3C%2FP%3E%3CP%3EThe%20formula%20is%20only%20updated%20if%20I%20retype%20the%20formula%20or%20if%20I%20re-open%20the%20file.%3C%2FP%3E%3CP%3EThe%20VLOOKUP%20formula%20in%20my%20file%20which%20links%20to%20another%20excel%20file%20(both%20of%20them%20are%20on%20my%20one%20drive)%20is%3A%3C%2FP%3E%3CP%3E%3DVLOOKUP(I7%2C'%3CA%20href%3D%22https%3A%2F%2Fgimoltd-my.sharepoint.com%2F%5B...%5D%2F%5BSprint%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgimoltd-my.sharepoint.com%2F%5B...%5D%2F%5BSprint%3C%2FA%3E%20management.xlsx%5DSheet1'!%24D%247%3A%24I%249%2C6)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENB%3A%20I%20used%20the%20%22%5B...%5D%22%20to%20make%20it%20cleaner%20here%20in%20this%20issue%20reporting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69742%22%20slang%3D%22en-US%22%3ERe%3A%20Refresh%20VLookup%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69742%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Brandi%20Nelson%2C%3C%2FP%3E%3CP%3EIf%20Calculation%20option%20has%20been%20set%20as%20manual%20in%20the%20file%2C%20then%20change%20it%20to%20automatic.%3C%2FP%3E%3CP%3E%3CSTRONG%3EFormulas%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3ECalculation%20Options%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3EAutomatic%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Vlookup%20function%20is%20refering%20to%20the%20data%20in%20the%20a%20different%20file%2C%20then%20confirm%20that%20the%20other%20file%20is%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20possible%20share%20the%20formula%2C%20data%20and%20the%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20let%20me%20know%20if%20this%20solves%20your%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVijaykumar%20Shetye%2C%3C%2FP%3E%3CP%3ESpreadsheet%20excellence%2C%3C%2FP%3E%3CP%3EPanaji%2C%20Goa%2C%20India%3C%2FP%3E%3C%2FLINGO-BODY%3E
Brandi Nelson
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies