Forum Discussion

Stephane KLOIS's avatar
Stephane KLOIS
Brass Contributor
Dec 07, 2018

Link between excel files

Hello guys,

I have a "bug" with Excel and SharePoint Online. At least, I hope it's a bug. 

 

I have a master file which is linked to another file to retrieve some data. To make it more clear, I open both files within OneDrive :

- In the master file, I select a cell then I put " = " in the cell 

then

- I click in the target file for and on the cell I need 

In the master file, Excel put a reference like : [XLS-Source.xlsx]Feuil1'!A3

 

When I close, then reopen the master file, the reference changes with the local filepath : ='C:\Users\xxxxxxx\OneDriveRep\rep1\[XLS-Source.xlsx]Feuil1'!A3

 

Before my migration, I dit some tests. I'm almost sure excel was saving a URL … something like : ='https://xxxxx.sharepoint.com/sites/siteSP/Documents/[XLS-Source.xlsx]Feuil1'!A3

 

Has anyone encountered the same issue ? Is there a workaround ?

 

 

  • Ok, I did some tests again.

    It appears that there are no issue when both files are within the same repository. Excel changes the filepath with a URL and the link works fine. 

    With different repository, Excel uses the filepath with the "C" drive :(

Resources