Solved

Re-establishing Excel 2007 Links when the file is moved

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

617 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