I got nothing on excel specifically but is the original server going out of service? If yes you can fake it out with a WINS and/or DNS entry.
From: Oliver Marshall [mailto:[email protected]] Sent: Monday, September 26, 2011 11: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
