?
Solved

Re-establishing Excel 2007 Links when the file is moved

Posted on 2011-02-23
2
Medium Priority
?
369 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 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

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…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

621 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