Share cell data between workbooks

Copper Contributor

Hi, 

 

I have been searching on the internet to a solution to this, but until now I have fallen short on an answer, so would really appreciate some assistance. 

 

Can and how do you share cell data between workbooks with excel. I can find a lot of information regarding desktop excel here, https://support.office.com/en-ie/article/create-an-external-reference-link-to-a-cell-range-in-anothe..., but nothing on excel online. 

 

Many thanks, 

 

Greig

3 Replies

Its quite simple sir, but one thing you have to keep in mind that the excel files you want to linked should be saved FIRST in a specific location (ie in a FOLDER) 

keep open the excel files and start with "=" parameter

and now are able to link. @gcooke75 

@Gourab Dasgupta , afraid that doesn't work with Excel Online

yes indeed