none
When excel file is checked in sharepoint, links in the document get corrupted.

    Frage

  • We have SharePoint 2013 on premise. Users check in and check out documents. Some  of the links get corrupted and the vti_history extension gets added which breaks all the embedded links.

    Donnerstag, 14. Juni 2018 20:17

Alle Antworten

  • Hi,

    From your description, you are using embedded links in your excel. And they get corrupted after you check in/out document in SP document library.

    You can try below two methods for solving your issue.

    Method 1:

    Unchecking of the "Update links on save" checkbox BEFORE adding hyperlinks.Please follow these steps:

    1. Save the excel file to your local machine.

    2. Delete existing hyperlinks.

    3. Now in Excel go to Options and under General tab click Web Options and on the Files tab uncheck the "Update links on save". Click "OK".

    4. After this add the hyperlinks again. And re-upload the file into SP site.

    This time check the results.

    Method 2:

    Use the excel formula =Hyperlink(Link Address, [Friendly Name]) instead of the embedding the hyperlink in the text.

    Best regards,

    Allen Bai


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Freitag, 15. Juni 2018 05:38