Linking a cell from a OneDrive excel sheet to another OneDrive excel sheet in different workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-3485514%22%20slang%3D%22en-US%22%3ELinking%20a%20cell%20from%20a%20OneDrive%20excel%20sheet%20to%20another%20OneDrive%20excel%20sheet%20in%20different%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3485514%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20a%20cell%20in%20sheet%20A%20of%20workbook%201%20display%20the%20cell%20from%20sheet%20X%20in%20workbook%202.%3C%2FP%3E%3CP%3EBoth%20workbooks%20are%20in%20the%20same%20parent%20folder%20with%20different%20sub%20folders.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20all%20this%20to%20be%20done%20with%20OneDrive%20apps%2C%20not%20desktop%20app.%20Any%20help%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3485514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3485924%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20a%20cell%20from%20a%20OneDrive%20excel%20sheet%20to%20another%20OneDrive%20excel%20sheet%20in%20different%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3485924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1418549%22%20target%3D%22_blank%22%3E%40Zachary1999%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%23ID0EBH%3DWeb%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20an%20external%20reference%20between%20cells%20in%20different%20workbooks%3C%2FA%3E%3C%2FP%3E%3CP%20class%3D%22%22%3EOpen%20the%20workbook%20that%20will%20contain%20the%20external%20reference%20(the%20destination%20workbook%2C%20also%20called%20the%20formula%20workbook)%20and%20the%20workbook%20that%20contains%20the%20data%20that%20you%20want%20to%20link%20to%20(the%20source%20workbook%2C%20also%20called%20the%20data%20workbook).%3C%2FP%3E%3CP%3EIn%20the%20source%20workbook%2C%20select%20the%20cell%20or%20cells%20you%20want%20to%20link.%3C%2FP%3E%3CP%3EPress%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECtrl%2BC%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eor%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EHome%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EClipboard%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECopy%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3ESwitch%20to%20the%20destination%20workbook%2C%20and%20then%20click%20the%20worksheet%20where%20you%20want%20the%20linked%20data%20to%20be%20placed.%3C%2FP%3E%3CP%3ESelect%20the%20cell%20where%20you%20want%20to%20place%20the%20linked%20data%2C%20then%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EHome%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EClipboard%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPaste%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EPaste%20Link%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EExcel%20will%20return%20the%20data%20you%20copied%20from%20the%20source%20workbook.%20If%20you%20change%20it%2C%20it%20will%20automatically%20change%20in%20the%20destination%20workbook%20when%20you%20refresh%20your%20browser%20window.%3C%2FP%3E%3CP%3ETo%20use%20the%20link%20in%20a%20formula%2C%20type%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3D%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ein%20front%20of%20the%20link%2C%20choose%20a%20function%2C%20type%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E(%3C%2FSTRONG%3E%2C%20and%20then%20type%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E)%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eafter%20the%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20with%20these%20information%20%2F%20links.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

I'm trying to make a cell in sheet A of workbook 1 display the cell from sheet X in workbook 2.

Both workbooks are in the same parent folder with different sub folders.

 

I want all this to be done with OneDrive apps, not desktop app. Any help would be greatly appreciated!

 

Thanks

1 Reply

@Zachary1999 

Create an external reference between cells in different workbooks

Open the workbook that will contain the external reference (the destination workbook, also called the formula workbook) and the workbook that contains the data that you want to link to (the source workbook, also called the data workbook).

In the source workbook, select the cell or cells you want to link.

Press Ctrl+C or go to Home > Clipboard > Copy.

Switch to the destination workbook, and then click the worksheet where you want the linked data to be placed.

Select the cell where you want to place the linked data, then go to Home > Clipboard > Paste > Paste Link.

Excel will return the data you copied from the source workbook. If you change it, it will automatically change in the destination workbook when you refresh your browser window.

To use the link in a formula, type = in front of the link, choose a function, type (, and then type ) after the link.

 

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)