Re: mass change of hyperlinks in Excel

[Dan <dan27649@xxxxxxxxx>]

Excellent find, Peter!  I can't believe I didn't find this the last time we
had to go through this a few years ago.  This is definitely useful for
future use.

Thanks!
- Dan

On Thu, May 28, 2009 at 2:19 PM, Peter Dow <maillist@xxxxxxxxxxxxxxx> wrote:

> Hi Dan,
>
> For future reference, perhaps this excerpt from the Excel help would work:
>
> ---
> Set the base address for the hyperlinks in a workbook
>
> By default, unspecified paths to hyperlink destination files are
> relative to the location of the active workbook. Use this procedure when
> you want to set a different default path. Each time you create a
> hyperlink to a file in that location, you'll only have to specify the
> file name, not the path, in the Insert Hyperlink dialog box.
>
> On the File menu, click Properties.
> Click the Summary tab.
> In the Hyperlink base box, type the path you want to use.
>
> Note: You can override the hyperlink base address by using the full, or
> absolute, address for the hyperlink in the Insert Hyperlink dialog box.
> ---
>
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
>
>
> Dan wrote:
> > On Thu, May 28, 2009 at 1:24 PM, John Taylor <lists@xxxxxxxxxxxxxxxxxxxx
> > wrote:
> >
> >
> > > Dan,
> > >
> > > Are the file servers running Windows? If so, your server people can
> solve
> > > this using DFS, which is how it should have been setup in the first
> place.
> > >
> >
> >
> > These are Windows servers, and I have no idea about whether they're using
> > DFS.  The bottom line is, as I alluded to in an earlier post, is that
> > nothing at that level gets done around here without a project, a
> committee,
> > a cost/benefit analysis, and testing up the wazoo.  It'd be a minimum of
> two
> > months before anything like this could be enacted.
> >
> > Heck, I've been moaning off and on for two years about upgrading DBU on
> our
> > 400s from version 6.0 to 8.0!  Helloooo!  (I finally got someone to start
> on
> > this, but this, too, will require an impact study of some sort.)
> >
> > When things of this nature need to be done around here, it's best to just
> > figure out how it can be done without having to involve the
> infrastructure
> > support folks.  The downside of working in a mega-corporation.
> >
> > - 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.