Linking two workbooks (one owned by another user on OneDrive)

%3CLINGO-SUB%20id%3D%22lingo-sub-2087838%22%20slang%3D%22en-US%22%3ELinking%20two%20workbooks%20(one%20owned%20by%20another%20user%20on%20OneDrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2087838%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20link%20two%20workbooks%20-%20workbook%20A%20(owned%20by%20myself%2C%20stored%20locally)%20and%20workbook%20B%20(owned%20by%20another%20user%2C%20shared%20via%20OneDrive).%20Workbook%20B%20is%20updated%20as%20it%20is%20connected%20to%20%3CEM%3Eanother%3C%2FEM%3E%20source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20treat%20workbook%20B%20as%20the%20master%2C%20so%20I%20cannot%20make%20any%20changes%20to%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20would%20like%20to%20have%20workbook%20A%20have%20worksheets%20that%20are%20identical%20to%20the%20worksheets%20in%20workbook%20B%2C%20and%20have%20it%20refresh%20in%20the%20same%20way%20that%20workbook%20B%20refreshes%20-%20the%20only%20difference%20being%20that%20I%20can%20make%20changes%20in%20workbook%20A%20and%20they%20would%20remain%20after%20each%20update%2Frefresh.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2087838%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089754%22%20slang%3D%22de-DE%22%3ESubject%3A%20Linking%20two%20workbooks%20(one%20owned%20by%20another%20user%20on%20OneDrive)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089754%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F939388%22%20target%3D%22_blank%22%3E%40elizabethsong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWork%20with%20worksheet%20data%20in%20OneDrive%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-worksheet-data-in-onedrive-c051a205-1c06-4feb-94d8-793b0126b53a%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-worksheet-data-in-onedrive-c051a205-1c06-4feb-94d8-793b0126b53a%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I am trying to link two workbooks - workbook A (owned by myself, stored locally) and workbook B (owned by another user, shared via OneDrive). Workbook B is updated as it is connected to another source.

 

I would like to treat workbook B as the master, so I cannot make any changes to it. 

However, I would like to have workbook A have worksheets that are identical to the worksheets in workbook B, and have it refresh in the same way that workbook B refreshes - the only difference being that I can make changes in workbook A and they would remain after each update/refresh. Is this possible?

 

3 Replies

@elizabethsong 

 

Work with worksheet data in OneDrive

https://support.microsoft.com/en-us/office/work-with-worksheet-data-in-onedrive-c051a205-1c06-4feb-9...

 

* Knowing the Excel version and operating system would also be an advantage.

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino 

Nope, you can't link workbooks for Excel Online. More exactly, that's limited functionality available for small portion of insiders.

I didn't mean anything else either...