I have been experiencing the oddest thing. I have a excel spreadsheet that has links within the document that are linked to a network drive. The links work perfectly in the excel spreadsheet until I upload the excel workbook to the SP13 document library. When I upload the workbook to the document library the URL is changed to the document library URL automatically. Has anyone experienced this issue before? Thanks for your help.
You may need to set "Update links on save" to false prior to adding your hyperlinks to the Excel spreadsheet.
In Excel 2010:
- uncheck "Update links on save" in Options > General > Web Options > Files tab
In Excel 2013:
- uncheck "Update links on save" in Options > Advanced > Web Options (under "General") > Files tab
After changing the Excel setting, re-create your hyperlinks in the spreadsheet, re-upload to SharePoint, and the links ought to be correct.