Home

Link between excel files

Contributor

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 ?

 

 

1 Reply
Highlighted

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 :(

Related Conversations
Multiple Conditional Formatting
Ray_Ray in Excel on
0 Replies
IF Function
Zaharyshka8 in Excel on
0 Replies
Changing Data Source
cjkim92 in Excel on
0 Replies
Convertion d'heure
Philaos-49 in Excel on
0 Replies
Copying work sheet form with formulas
Allsons in Excel on
1 Replies
excel help
RussWill227 in Excel on
2 Replies