scalc – dynamic link between workbook

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.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.