let’s say that u have to workbook open and you want workbook A is in workbook B as an update link. we used to use =sheet.b3:x3 if the link is inside its workbook.
all you have to do is select the area in workbook A you would like to link and copy, then go to workbook B and paste special or ctrl+shift+v or go to menu edit – paste special. choose link.
example paste link
we can use this link paste as a formula with vlookup or something like that.
becarefull to pay attension to the number format. if you want to sum in your link file it will failed if the original format number is wrong.