Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
Can't Access Charts Linked to Files on Server | Excel Discussion (Misc queries) | |||
Moving files which are linked | Excel Discussion (Misc queries) | |||
save .xls files to a server | Excel Discussion (Misc queries) | |||
Moving linked Excel/Access files to another machine | Links and Linking in Excel |