External links to files saved in shared drives that uses different letters

Hi,

Our users are split by departments and in each department, they mapped specific shared file servers into specific drives (K:, T: etc).
some of the file servers are shared across different departments but the staff in these departments do not use the same letters for the drive.

We have this workbook that has external links to the file servers..example.."W:\1_C\1.13 Data\2018\0318\Report\Draft\FileJan"

But this W drive path is mapped as X in another user. That means when this user open the report, the file is unable to update itself and the user needs to use edit links to reset the source path to X.

This is a HUGE workbook and I am hoping to find a solution without changing the drives in all the users. I cannot use VB because of the lack of VB competence in the office.

We are using Excel 2016 and windows 10. The workbook is in xlsx format.

Please help!

dont use drive letters, use full UNC paths,
\\server\folder\folder\file.txt

Hi

So i should just use "find/replace" to replace all the "W.:\" to \\server\xx\?

This file is so huge that just changing source takes ages.