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...
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. 🙂
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/ba-p/1590314
The only "problem" is its on excel online. If this is no problem you can use this option.
Best regards
