Excel broken links

%3CLINGO-SUB%20id%3D%22lingo-sub-287019%22%20slang%3D%22en-US%22%3EExcel%20broken%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287019%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20experienced%20a%20weird%20MS%20Excel%20behavior%20and%20I%20am%20unsure%20if%20it%20is%20such.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Let's%20say%20I%20created%20a%20MS%20Excel%20document%20in%20version%201803%20and%20it%20contains%20many%20links%20from%20the%20same%20source%2C%20say%3A%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fbcd-efg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fbcd-efg%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fcde-fgh%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fabc.com%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fcde-fgh%3C%2FA%3E%26nbsp%3Band%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Save%20the%20Excel%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)%20Open%20the%20document%20and%20click%20one%20of%20the%20link%20-%20OK%20previously.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4)%20Then%2C%20our%20organization%20had%20the%20MS%20Offce%20upgraded%20to%20MS%20Office%20365.%20And%20the%20option%20(Options%5CAdvanced%5CWeb%20Options%5CFiles%20tab)%26nbsp%3Bto%20Update%20links%20on%20save%20was%20checked%20by%20default%20because%20we%20didn't%20know.%20Next%2C%20the%20document%20also%20migrated%20to%20another%20system.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5)%20Hence%2C%20the%20links%20has%20been%20automatically%20converted%20to%20as%20below%20after%20one%20of%20the%20user%20saved%20the%20document%3A%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2F..%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%23000000%22%3E..%2F..%2F..%2F..%2F..%2F..%2F%3C%2FFONT%3Eshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2F..%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fbcd-efg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%23000000%22%3E..%2F..%2F..%2F..%2F..%2F..%2F%3C%2FFONT%3Eshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fbcd-efg%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2F..%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fcde-fgh%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%23000000%22%3E..%2F..%2F..%2F..%2F..%2F..%2F%3C%2FFONT%3Eshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fcde-fgh%3C%2FA%3E%26nbsp%3Band%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E6)%20Next%2C%20open%20the%20document%20and%20click%20one%20of%20the%20link.%3C%2FP%3E%3CP%3E-%20Before%20clicking%20the%20link%2C%20the%20link%20looks%20like%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2F..%2Fshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%20color%3D%22%23000000%22%3E..%2F..%2F..%2F..%2F..%2F..%2F%3C%2FFONT%3Eshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%2F%2FSpacesStore%2Fabc-cde%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20Click%20the%20link%20to%20open%2C%20it%20shows%20the%20link%20is%20broken%20and%20not%20able%20to%20load%20the%20page.%3C%2FP%3E%3CP%3E-%20Then%2C%20we%20checked%20the%20URL%20in%20the%20browser%20and%20found%20the%20link%20has%20changed%20automatically%26nbsp%3Bto%20-%20%3CA%20target%3D%22_blank%22%3E%3CFONT%20color%3D%22%23000000%22%3E..%2F..%2F..%2F..%2F..%2F..%2F%3C%2FFONT%3Eshare%2Fpage%2Fdocument-details%3FnodeRef%3Dworkspace%3A%5C%5CSpacesStore%5Cabc-cde%3C%2FA%3E%3C%2FP%3E%3CP%3E-%20Note%20that%20the%20forward%20slash%20has%20been%20automatically%20converted%20to%20back%20slash%20in%20Excel%20and%20also%20in%20the%20URL.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E7)%20We%20have%20hundred%20of%20broken%20links%20in%20the%20document%20and%20it%20is%20not%20usable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E8)%3C%2Fimg%3E%20We%20have%20tried%20(Info%5CProperties%5CAdvanced%20Properties)%20Hyperlink%20base%20and%20it%20is%20not%20working.%20Other%20methods%20tried%20included%20adding%20Trusted%20Locations%2C%20uncheck%20Protected%20View%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E9)%20Please%20deploy%20your%20best%20arsenal%20guy%20to%20advise%20us%20how%20to%20fix%20such%20thing.%20I%20have%20tried%20googling%20in%20the%20web%20but%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ERachel%20Lim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-287019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESkype%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi

 

I experienced a weird MS Excel behavior and I am unsure if it is such.

 

1) Let's say I created a MS Excel document in version 1803 and it contains many links from the same source, say:

- https://abc.com/share/page/document-details?nodeRef=workspace://SpacesStore/abc-cde

- https://abc.com/share/page/document-details?nodeRef=workspace://SpacesStore/bcd-efg

- https://abc.com/share/page/document-details?nodeRef=workspace://SpacesStore/cde-fgh and etc.

 

2) Save the Excel online.

 

3) Open the document and click one of the link - OK previously.

 

4) Then, our organization had the MS Offce upgraded to MS Office 365. And the option (Options\Advanced\Web Options\Files tab) to Update links on save was checked by default because we didn't know. Next, the document also migrated to another system.

 

5) Hence, the links has been automatically converted to as below after one of the user saved the document:

- ../../../../../../share/page/document-details?nodeRef=workspace://SpacesStore/abc-cde

- ../../../../../../share/page/document-details?nodeRef=workspace://SpacesStore/bcd-efg

- ../../../../../../share/page/document-details?nodeRef=workspace://SpacesStore/cde-fgh and etc.

 

6) Next, open the document and click one of the link.

- Before clicking the link, the link looks like - ../../../../../../share/page/document-details?nodeRef=workspace://SpacesStore/abc-cde

- Click the link to open, it shows the link is broken and not able to load the page.

- Then, we checked the URL in the browser and found the link has changed automatically to - ../../../../../../share/page/document-details?nodeRef=workspace:\\SpacesStore\abc-cde

- Note that the forward slash has been automatically converted to back slash in Excel and also in the URL.

 

7) We have hundred of broken links in the document and it is not usable.

 

8) We have tried (Info\Properties\Advanced Properties) Hyperlink base and it is not working. Other methods tried included adding Trusted Locations, uncheck Protected View settings.

 

9) Please deploy your best arsenal guy to advise us how to fix such thing. I have tried googling in the web but to no avail.

 

Thank you.

 

Regards

Rachel Lim

0 Replies