Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Re-establishing Excel 2007 Links when the file is moved

Posted on 2011-02-23
2
Medium Priority
?
364 Views
Last Modified: 2012-05-11
We have created a network directory, below which are 3 sub-directories.  Below these directories are numerous Excel 2007 spreadsheets.  These are linked to an "overall" spreadsheet.  Due to network inherited right issues, we need to adjust the directory structure of the network directory, thus changing the path file name of the Excel documents.  Is there a way to automatically re-establish the links properly in the overall spreadsheet?  
0
Comment
Question by:gsfc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
Mantvydas earned 2000 total points
ID: 34961946
I would do the Replace All here.

Say you had E:\Folder1\Folder2\Subfolder1 and then you have H:\Folder3\Folder4\Subfolder1.

In the overall workbook I would just hit Ctrl+H, and do a replace all from E:\Folder1\Folder2 to H:\Folder3\Folder4.
0
 

Author Closing Comment

by:gsfc
ID: 34961989
I believe the user was looking for something a bit more "automatic", but certainly the replace function will work.  They will have to do this at least 15-16 times, because of the number of linked files, but that's better than updating each cell individually.
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question