Forum Discussion
Create an external reference (link) to a cell range in another online document
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 doc...
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
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/ba-p/1590314
The only "problem" is its on excel online. If this is no problem you can use this option.
Best regards
https://techcommunity.microsoft.com/t5/excel-blog/workbook-link-support-coming-to-excel-for-the-web/ba-p/1590314
The only "problem" is its on excel online. If this is no problem you can use this option.
Best regards