Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

Globally change relative-addressed hyperlinks to absolute-addr

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Herman H - 17 Nov 2005 20:17 GMT
Excel spreadsheet has links to several files.  Can I globally change
relative-addressed links to absolute-addressed links? If not, what's easiest
way to make the change.  Files are not all in same folder.
Roland - 20 Nov 2005 01:45 GMT
Use with care, but try the functionality of find and replace available from
Edit > Find.

Find the constant portion of your hyperlink text, and replace it with the
new constant portion for the absolute address.

> Excel spreadsheet has links to several files.  Can I globally change
> relative-addressed links to absolute-addressed links? If not, what's easiest
> way to make the change.  Files are not all in same folder.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.