Linking excel sheets saved in One Drive or Sharepoint - Microsoft Community

when link different excel files saved in onedrive when saved creates website link instead of local path. link includes user such i.e  www.********.sharepoint.com/users/mxtax/mk tax/shared – documents/***** when reopen file can not access link not correct link. when manually change link www.********.sharepoint.com/sites/shared/shared documents
/***** it works. how can update our excel create valid link can use onedrive smoothly , not need search , correct every link???

in addition, opening excel files onedrive takes slow. there reason this?

hi miriam,

for second question, suggest post new thread in our forum. so, our engineers can slow issue further in new thread.

to better understand first question, i'd confirm following things:

1. how "link different excel file sasved in onedrive"? let know detailed steps? detailed steps try reproducing issue our side.

2. "create website link instead of local path", mean sync onedrive business folder computer? 

3. give 2 examples of link in file. mean url when firstly link worksheet in file , url when reopen file. use mydomain replace custom domain.

4. "it cannot access", please capture screenshot error message.

best regards,

tim

Office / OneDrive for Business / Other/unknown / Office 365 for business