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)