Link between Excel files on Share Point

Copper Contributor

Hello

To share information with my subsdiaries, I intended to use Sharepoint.

The aim is:

- from my consolidated file, I created a file (or plus) for each subsidiary, registered in Sharepoint (I did a copy of the part I want them to fulfill). The subsidiary fulfills the information.

- in the master file, I wanted to do a reference (as the files are similar) to the subsidiary file, using = ref of the cell in the subsdiary file.

Unfortunately, when I do that, I can do =, search in the subsidiary file (opened also in sharepoint), search the cell and press enter. But there is no result and I have only = (and an error result in my formulas) in the master file.

I hope I'm clear enough and that someone will be able to help me (I didn't expected this issue as I was previously used to Google and had no problem with that) 

1 Reply

@Nelly_T 

That's coming functionality, so far is available only for part of insiders Workbook Link support coming to Excel for the web