Solved

Re-establishing Excel 2007 Links when the file is moved

Posted on 2011-02-23
2
358 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 500 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

738 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