× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.