Re: mass change of hyperlinks in Excel

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.