Re: mass change of hyperlinks in Excel

[Booth Martin <booth@xxxxxxxxxxxx>]

Can't an alias be set up on the company DNS?  Say, Excel/  And then let 
the spreadsheets point to that, and that points to whatever you want it 
to point at?

Jim Essinger wrote:
> Good Question Dan, and one that I will be facing in the near future as we
> change our production LPAR from one I/P address to another.  Some of the
> Excel spreadsheets are still pointed at an older address, and I have to
> bring them up todate before we move to the new LPAR.
>
> I don't have an answer, but need to find one.  If I find one I will post,
> and I hope that you can do the same.
>
> Jim
>
> On Thu, May 28, 2009 at 9:36 AM, Dan <dan27649@xxxxxxxxx> wrote:
>
>   
> > The server gods in our company have, for reasons unknown to me or other
> > affected parties, again moved one of our major "applications" from one
> > server to a new server.  As a result, all of the hyperlinks in the
> > spreadsheets have to be changed to refer to the new server/path.  Each
> > spreadsheet may have upwards of 400 links to documents on this server, so
> > you see the impact that this change has.
> >
> > Is there a way to define the server/path once in a spreadsheet, like
> > assigning it to a symbolic name (like a drive letter), and then using that
> > symbolic name in the hyperlinks?
> >
> > When they did this previously, a few years ago, I searched for a "scan and
> > replace" utility, but found none (that were free, since that was my budget)
> > that would do this for hyperlinks.
> >
> > Advice / suggestions welcome.
> >
> > TIA,
> > Dan
> > --
> > This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
> > To post a message email: PcTech@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/pctech
> > or email: PcTech-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/pctech.
> >
> >     
> > ------------------------------------------------------------------------
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com 
> > Version: 8.5.339 / Virus Database: 270.12.43/2139 - Release Date: 05/28/09 08:10:00
> >
> >