Link between Excel files on Share Point

%3CLINGO-SUB%20id%3D%22lingo-sub-1894516%22%20slang%3D%22en-US%22%3ELink%20between%20Excel%20files%20on%20Share%20Point%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894516%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3ETo%20share%20information%20with%20my%20subsdiaries%2C%20I%20intended%20to%20use%20Sharepoint.%3C%2FP%3E%3CP%3EThe%20aim%20is%3A%3C%2FP%3E%3CP%3E-%20from%20my%20consolidated%20file%2C%20I%20created%20a%20file%20(or%20plus)%20for%20each%20subsidiary%2C%20registered%20in%20Sharepoint%20(I%20did%20a%20copy%20of%20the%20part%20I%20want%20them%20to%20fulfill).%20The%20subsidiary%20fulfills%20the%20information.%3C%2FP%3E%3CP%3E-%20in%20the%20master%20file%2C%20I%20wanted%20to%20do%20a%20reference%20(as%20the%20files%20are%20similar)%20to%20the%20subsidiary%20file%2C%20using%20%3D%20ref%20of%20the%20cell%20in%20the%20subsdiary%20file.%3C%2FP%3E%3CP%3EUnfortunately%2C%20when%20I%20do%20that%2C%20I%20can%20do%20%3D%2C%20search%20in%20the%20subsidiary%20file%20(opened%20also%20in%20sharepoint)%2C%20search%20the%20cell%20and%20press%20enter.%20But%20there%20is%20no%20result%20and%20I%20have%20only%20%3D%20(and%20an%20error%20result%20in%20my%20formulas)%20in%20the%20master%20file.%3C%2FP%3E%3CP%3EI%20hope%20I'm%20clear%20enough%20and%20that%20someone%20will%20be%20able%20to%20help%20me%20(I%20didn't%20expected%20this%20issue%20as%20I%20was%20previously%20used%20to%20Google%20and%20had%20no%20problem%20with%20that)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1894516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1894554%22%20slang%3D%22en-US%22%3ERe%3A%20Link%20between%20Excel%20files%20on%20Share%20Point%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871612%22%20target%3D%22_blank%22%3E%40Nelly_T%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20coming%20functionality%2C%20so%20far%20is%20available%20only%20for%20part%20of%20insiders%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fworkbook-link-support-coming-to-excel-for-the-web%2Fba-p%2F1590314%22%20target%3D%22_blank%22%3EWorkbook%20Link%20support%20coming%20to%20Excel%20for%20the%20web%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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