| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
lost Hypertext links defined in cells of an excel spreadsheet
Hyperlink addresses can be saved as relative to some path (the path of
the workbook by default, or the workbook's "hyperlink base") or as absolute addresses. If you move the workbook then the relative hyperlinks no longer work. For that reason I suggest setting a hyperlink base which does not exist. This will force all hyperlink addresses to be absolute. In Excel 2003 and earlier File Properties Summary Hyperlink Base Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel; hypertext from web addr? | Excel Discussion (Misc queries) | |||
| Create a query which links criterias to some cells in spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I force Excel to recreate links it lost in conversion. | Excel Discussion (Misc queries) | |||
| Hypertext Links | Excel Worksheet Functions | |||
| How can I globally disable the Hypertext link option in Excel? | Setting up and Configuration of Excel | |||
Hybrid Mode
