When opening an excel file using UNC Path, formulas update loosing part of Path

[JustJohn91]

Hi All,

Apologies if this is already answered but I couldnt find an answer anywhere. I have encountered an odd issue and hoping someone can help.

I have an excel Statistics workbook stored in OrgUnit\Subfolder1\SubFolder2\SubFolder3\SubFolder4\. This workbook is linked to three other Log workbooks in OrgUnit\Subfolder1\SubFolder2\SubFolder5\. When I open the Statistics workbook using the file explorer all works as intended. However If I open the workbook using the UNC Path for the OrgUnit, part of the OrgUnit UNC Path isnt appearing in the formula, causing my links to break.

OrgUnit UNC Path is \\Organisation.ie\groups\Location\OrgUnit so the UNC Path for one of the Log workbooks should be \\Organisation.ie\groups\Location\OrgUnit\Subfolder1\SubFolder2\SubFolder5\LogWorkbook.xlsm.
However the formula in the Statistics workbook will reference \\Organisation.ie\groups\Subfolder1\SubFolder2\SubFolder5\LogWorkbook.xlsm, dropping the Location and OrgUnit.

Any insights into what is happening are warmly welcomed.