Our commercial secretaries have a problem with a quotation spreadsheet.

We have a mix of users Excel 2010 and 2013.

Within this spreadsheet there are hyperlinks to external documents such as PDFs.

Looking at the path to a non-working link, the server root location appears to have been lost, but the rest of the path is still in place.  For instance, editing the path to a hyperlink shows ../../SPARES/PT/PT2000-PT2099/PT2018/12510.PDF where the actual path is G:/SPARES/PT/PT2000 - PT2099/PT2018/12510.PDF.

The G: drive is a mapped network drive if that makes a difference.

Anyone know why these links have been re-written/have lost connection to the original documents - the spreadsheet has not been relocated.

Thanks

Phil

That's strange, when I hover the cursor over the hyperlink in the file it displays what-appears-to-be the correct path:

file:///\\Europa-FP\Data1\SPARES/PT/PT2000-PT2099/PT2018/12510.PDF

This is the full UNC path - but the user inserts these using the mapped drive letter G: for the path \\Europa-FP\Data1.

But when I click on this I simply get "Cannot open the specified file".

So at some point the file path is changing from mapped to UNC, but the location displayed in the Edit Hyperlink dialog box has neither the UNC nor the Mapped server root of the path, just ../../.

Any ideas out there??

Thanks

Phil

See this:

https://support.microsoft.com/en-us/kb/328440/en-us?wa=wsignin1.0

When a source data workbook is linked, the link is established   based on the way that the workbook was opened. If the workbook was opened over   a mapped drive, the link is created by using a mapped drive. The link remains   that way regardless of how the source data workbook is opened in the future. If   the source data file is opened by a UNC path, the link does not revert to a   mapped drive, even if a matching drive is available. If you have both UNC   and mapped drive links in the same file, and the source files are open at the   same time as the destination file, only those links that match the way the file   was opened will react as hyperlink. Specifically, if you open the file through   a mapped drive and change the values in the source file, only those links   created to the mapped drive will update immediately.

The link   displayed in Excel may appear differently depending on how the workbook was   opened. The link may appear to match either the root UNC share or the root   drive letter that was used to open the file.

KR