+1 For just one masterfile I would do exactly that. Op 26 sep. 2011 18:04 schreef "Kim Longenbaugh" <[email protected]> het volgende: > If you're updating the master with the new locations, why not use the old ctrl-h, put the old link in the top text box, with the new link in the bottom text, and click "replace all". You can test the process first by selecting "replace" which will do just one instance. > > Or, like some others have said, you could do some fancy scripting. > > From: Oliver Marshall [mailto:[email protected]] > Sent: Monday, September 26, 2011 10:17 AM > To: NT System Admin Issues > Subject: Updating all the links in a spreadsheet (search and replace) > > Anyone know of a tool that will allow us to replace all the links within a spreadsheet, ideally in a folder full of them, with a new link? > > We have a Master spreadsheet that pulls data out of some 300 spreadsheets within a nest of folders. We are moving the whole lot to a new server and need to update all the links and references from \\server\share\files\blah.xls<file:///\\server\share\files\blah.xls> to \\server_two\share\files\blah.xls<file:///\\server_two\share\files\blah.xls>. > > Any suggestions? > > Olly > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected]<mailto: [email protected]> > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
