Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,696
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to make Excel linked to SQL Server 2005 worksheet editable? Permood Excel Discussion (Misc queries) 0 July 18th 08 05:06 PM
Can't Access Charts Linked to Files on Server [email protected] Excel Discussion (Misc queries) 0 April 3rd 07 01:54 PM
Moving files which are linked chrismc1972 Excel Discussion (Misc queries) 1 January 23rd 07 09:28 PM
save .xls files to a server fofo Excel Discussion (Misc queries) 1 May 25th 06 04:23 PM
Moving linked Excel/Access files to another machine CaroleN Links and Linking in Excel 1 August 11th 05 01:58 PM


All times are GMT +1. The time now is 12:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"