Create an external reference (link) to a cell range in another online document

%3CLINGO-SUB%20id%3D%22lingo-sub-2394801%22%20slang%3D%22en-US%22%3ECreate%20an%20external%20reference%20(link)%20to%20a%20cell%20range%20in%20another%20online%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394801%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20create%20a%20reference%20with%20a%20document%20that%20is%20online%20(on%20a%20sharepoint).%3CBR%20%2F%3EI%20use%20index%2Bequiv%20formulas%20between%20two%20documents%20on%20my%20desktop%2C%20which%20work%20perfectly.%20Only%20one%20of%20the%20documents%20is%20online%20and%20the%20formulas%20don't%20work%20anymore%20with%20a%20document%20on%20Sharepoint.%3CBR%20%2F%3EIndeed%2C%20the%20access%20path%20to%20the%20document%20includes%20the%20name%20of%20my%20computer%20and%20therefore%20depends%20on%20my%20session.%3CBR%20%2F%3EDo%20you%20have%20any%20ideas%20for%20solutions%3F%3CBR%20%2F%3EThanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2394801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394856%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20an%20external%20reference%20(link)%20to%20a%20cell%20range%20in%20another%20online%20document%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394856%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1065561%22%20target%3D%22_blank%22%3E%40dphn_u%3C%2FA%3E%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20understand%20you%20right%2C%20you%20should%20upload%20them%20both%20on%20the%20same%20system%2C%20that%20you%20dont%20have%20a%20problem%20with%20the%20reference%2C%20otherwise%20you%20will%20always%20have%20some%20trouble%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIsn't%20it%20possible%20to%20create%20just%20an%20other%20sheet%20in%20the%20first%20excel%20document%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I am looking to create a reference with a document that is online (on a sharepoint).
I use index+equiv formulas between two documents on my desktop, which work perfectly. Only one of the documents is online and the formulas don't work anymore with a document on Sharepoint.
Indeed, the access path to the document includes the name of my computer and therefore depends on my session.
Do you have any ideas for solutions?
Thanks in advance

 

3 Replies
Hi @dphn_u ,

When I understand you right, you should upload them both on the same system, that you dont have a problem with the reference, otherwise you will always have some trouble

Isn't it possible to create just an other sheet in the first excel document?

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.
Thanks for your answer.
I can't create another sheet, the two docs are used by different persons. And this two docs are located on different files on a Sharepoint.
The thing is that for me it's working, but for an other user no, they don't see the last update except if I open first the doc (kind of uploading). I would like that the two documents will not be linked with my computer ...
I don't know if this is actually possible on documents online ?
Thank you for your time
Ah okay, I guess you are searching for this.

https://techcommunity.microsoft.com/t5/excel-blog/workbook-link-support-coming-to-excel-for-the-web/...

The only "problem" is its on excel online. If this is no problem you can use this option.
Best regards