Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Globally change relative-addressed hyperlinks to absolute-addr
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Globally change relative-addressed hyperlinks to absolute-addr
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. "Herman H" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
How can I globally change the formatting of all my comments in Exc | Excel Discussion (Misc queries) | |||
How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Edit Hyperlinks Globally | Excel Worksheet Functions |