Hardcoding paths for linked data

[Casper1977]

Dear Forumusers,

Does anyone know how you can prevent the "path" of linked data from changing if other users open the linked data in the same excell session but have different network mappings.

As example:

Book1 has data imported from source1 located at \\server1\department\project\folder1\.

Now a user opens both files in one excel session and has \\server1\department\ mapped as E:\.

When he closes and saves all files the link has now been changed to E:\project\folder1\ and other users with different or no mappings will get error's.

Apart from educating people to not open book1 and source file in one session if have not been able to make this dummy proof.

Anyone that has had similar problems and found an solution?

Regards and thanks for any help,

Casper

 

[Weaver]

Welcome to the board.

We have a similar problem and I have some ideas how to 'work around' it, although they all involve macros.

My current theory goes along the lines of resolving the full network path name of all links when the sheet is saved but I've not implemented it yet as it seems a bit heavy handed and I'm not 100% confident it won't irrevocably damage files in the process.

 

[dejvnull]

Dear Forumusers,

Does anyone know how you can prevent the "path" of linked data from changing if other users open the linked data in the same excell session but have different network mappings.

As example:

Book1 has data imported from source1 located at \\server1\department\project\folder1\.

Now a user opens both files in one excel session and has \\server1\department\ mapped as E:\.

When he closes and saves all files the link has now been changed to E:\project\folder1\ and other users with different or no mappings will get error's.

Apart from educating people to not open book1 and source file in one session if have not been able to make this dummy proof.

Anyone that has had similar problems and found an solution?

Regards and thanks for any help,

Casper

We have the exact same problem and so far I have not found any "good" tools except this from MapiLabs.
I would be very happy to hear about a solution or a good way to remediate this problem.

/Dave