Mapped Drive Link Problems

[Chewyhairball]

Hi Guys
I have a spreadsheet in which one cell contains a link to another spreadsheet

='M:\Entry\Data\Share\filedata\waste\NewWaste\[Unidentified]USED'!R7C7

30+ people have access to this sheet and regularly update the sheet and save it.

Randomly though there is a 'Links not found' message and when i check the formula it has changed to

'\\ss2a\sp\data\Entry\Data\Share\filedata\waste\NewWaste\[Unidentified]USED'!R7C7

'\\ss2a\sp\data is the server that our 'M' drive is mapped to.

I have read some stuff about UNC and mapped links but i dont really understand what is happening.
I am guessing that someone is opening up the Spreadsheet differently which changes the link address but i have know idea how how that works.

any help would be greatly appreciated.

Thanks

Rory

 

[Alex Blakenburg]

I don't currently have access to any network drives but if I had to guess,
you have one or more people who either do not have drive mapped at all or have it mapped to a different location and when they open the file they are having to browse to where the data is.

If you change from using M drive to a fully specified file path it should work for everyone.
Just be aware that this makes the full filename (including the path) longer and there is a limit of 260 characters.

 

[Chewyhairball]

Thanks Alex, ill give that a try

I don't currently have access to any network drives but if I had to guess,
you have one or more people who either do not have drive mapped at all or have it mapped to a different location and when they open the file they are having to browse to where the data is.

If you change from using M drive to a fully specified file path it should work for everyone.
Just be aware that this makes the full filename (including the path) longer and there is a limit of 260 characters

 

[Alex Blakenburg]

Let me know how you go.