Home

Share cell data between workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-562651%22%20slang%3D%22en-US%22%3EShare%20cell%20data%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562651%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20searching%20on%20the%20internet%20to%20a%20solution%20to%20this%2C%20but%20until%20now%20I%20have%20fallen%20short%20on%20an%20answer%2C%20so%20would%20really%20appreciate%20some%20assistance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20and%20how%20do%20you%20share%20cell%20data%20between%20workbooks%20with%20excel.%20I%20can%20find%20a%20lot%20of%20information%20regarding%20desktop%20excel%20here%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%3C%2FA%3E%2C%20but%20nothing%20on%20excel%20online.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreig%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-562651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eworkbook%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562807%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20cell%20data%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562807%22%20slang%3D%22en-US%22%3E%3CP%3EIts%20quite%20simple%20sir%2C%20but%20one%20thing%20you%20have%20to%20keep%20in%20mind%26nbsp%3Bthat%20the%20excel%20files%20you%20want%20to%20linked%20should%20be%20saved%20FIRST%20in%20a%20specific%20location%20(ie%20in%20a%20FOLDER)%26nbsp%3B%3C%2FP%3E%3CP%3Ekeep%20open%20the%20excel%20files%20and%20start%20with%20%22%3D%22%20parameter%3C%2FP%3E%3CP%3Eand%20now%20are%20able%20to%20link.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341198%22%20target%3D%22_blank%22%3E%40gcooke75%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-563048%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20cell%20data%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-563048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130464%22%20target%3D%22_blank%22%3E%40Gourab%20Dasgupta%3C%2FA%3E%26nbsp%3B%2C%20afraid%20that%20doesn't%20work%20with%20Excel%20Online%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-563225%22%20slang%3D%22en-US%22%3ERe%3A%20Share%20cell%20data%20between%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-563225%22%20slang%3D%22en-US%22%3Eyes%20indeed%3C%2FLINGO-BODY%3E
gcooke75
Occasional Visitor

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