ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moving linked files from one server to anoter one (https://www.excelbanter.com/excel-worksheet-functions/205281-moving-linked-files-one-server-anoter-one.html)

Gabriel Cisser

Moving linked files from one server to anoter one
 
I need to move a folder (F) from the old server O to a new server N with
several sub folders having excel files which are linked to another files in
the same sub folder and in others sub folders.

When I move de main folder (F), the link for the files linked to other in
other sub folders doesn´t change, I mean, the link continues being refered to
server O instead of server N.

I don´t want to change manually the links after moving to the new server N.

I appreciate any information on how to solve it.

Sean Timmons

Moving linked files from one server to anoter one
 
Go to Edit - Links. Select the files you are having issues with and click
Change Source. No muss, no fuss.

"Gabriel Cisser" wrote:

I need to move a folder (F) from the old server O to a new server N with
several sub folders having excel files which are linked to another files in
the same sub folder and in others sub folders.

When I move de main folder (F), the link for the files linked to other in
other sub folders doesn´t change, I mean, the link continues being refered to
server O instead of server N.

I don´t want to change manually the links after moving to the new server N.

I appreciate any information on how to solve it.


Gabriel Cisser

Moving linked files from one server to anoter one
 
Thanks for your answer, but the problem is that I have a lot of files, whith
lot of links in each one, so, I wanted to do it automatically.

"Sean Timmons" wrote:

Go to Edit - Links. Select the files you are having issues with and click
Change Source. No muss, no fuss.

"Gabriel Cisser" wrote:

I need to move a folder (F) from the old server O to a new server N with
several sub folders having excel files which are linked to another files in
the same sub folder and in others sub folders.

When I move de main folder (F), the link for the files linked to other in
other sub folders doesn´t change, I mean, the link continues being refered to
server O instead of server N.

I don´t want to change manually the links after moving to the new server N.

I appreciate any information on how to solve it.


Sean Timmons

Moving linked files from one server to anoter one
 
Then, if you've kept all fop your subfolders and such, do a find/replace...

Find: O:\path
Replace with: N:\path

So, if all files were in O:\Main\data

and the new are all under N:\HQ\User

just type in those entire paths.

If the files are now scattered, change source would be your best bet.

Depending on the length of your paths, you may need the files open prior to
performing the replace.

"Gabriel Cisser" wrote:

Thanks for your answer, but the problem is that I have a lot of files, whith
lot of links in each one, so, I wanted to do it automatically.

"Sean Timmons" wrote:

Go to Edit - Links. Select the files you are having issues with and click
Change Source. No muss, no fuss.

"Gabriel Cisser" wrote:

I need to move a folder (F) from the old server O to a new server N with
several sub folders having excel files which are linked to another files in
the same sub folder and in others sub folders.

When I move de main folder (F), the link for the files linked to other in
other sub folders doesn´t change, I mean, the link continues being refered to
server O instead of server N.

I don´t want to change manually the links after moving to the new server N.

I appreciate any information on how to solve it.



All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com