Solved

Re-establishing Excel 2007 Links when the file is moved

Posted on 2011-02-23
2
353 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
2 Comments
 
LVL 3

Accepted Solution

by:
Mantvydas earned 500 total points
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now