Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
j j is offline
external usenet poster
 
Posts: 128
Default Global update hyperlink address

A organizational change has prompted a request to re-assign a former folder
on the network to a different group. The current folder "owners" heavily use
hyperlinks within workbooks to other workbooks or documents. Is there a way
to globally update all hyperlinks to point to a new top level folder on the
network and retain all subfolder information?
ex: Old address M:\Engineering\...... will now be M:\ChemEngineering.....
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 903
Default Global update hyperlink address

I'm not sure if this will do it but I would try this first
http://www.oaltd.co.uk/MVP/Default.htm or directly to
http://www.oaltd.co.uk/MVP/MVPPage.asp#JanKarelPieterse
look for FlexFind by Jan Karel Pieterse

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"J" wrote in message ...
A organizational change has prompted a request to re-assign a former folder
on the network to a different group. The current folder "owners" heavily use
hyperlinks within workbooks to other workbooks or documents. Is there a way
to globally update all hyperlinks to point to a new top level folder on the
network and retain all subfolder information?
ex: Old address M:\Engineering\...... will now be M:\ChemEngineering.....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can one excelworksheet address update a different box on 2nd w/s celia ellis Excel Worksheet Functions 2 January 3rd 07 09:44 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
hyperlink a worksheet with no address Jared Excel Worksheet Functions 2 August 14th 06 02:16 PM
Moving rows with Hyperlink doesn't move hyperlink address Samad Excel Discussion (Misc queries) 15 June 22nd 06 12:03 PM
Global criteria update for formulas? Annabelle Excel Discussion (Misc queries) 3 February 3rd 06 11:38 PM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"