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
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies