Move Linked (UNC) excel files to a new server

[MEL33]

One of our depts. has many excel files linked across many folders on a server. Most are linked by using UNC. We are replaceing this server with a new one and I need to move all of these files and have the links point to the new server, without messing up the links.

 

[SkipVought]

Hi,

How about using Edit > Find/Replace?

Skip,
[sub]
[red][/red]
[/sub]

 

[MEL33]

Thanks for your input, but there are 1000's of excel files in hundreds of folders. Some with mutiple links and some with none.

 

[spiego]

MEL33,

Did you find a solution? I am having to do the same thing?

TIA

 

[SkipVought]

Not a simple solution. I'd use VBA.

Build a FROM TO table.

Macro record Changing FROM one server TO another.

Post back with your recorded code and a description of your table in Forum707.

Skip,
[sub]
[red][/red]
[/sub]