Re: mass change of hyperlinks in Excel

[Jim Essinger <dilbernator@xxxxxxxxx>]

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.