| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a global change of Hyperlink addresses?
I have a large group of hyperlinks that have changed the base part of their
address. Probably when the spreadsheet quit and I had to recover the file. Instead of pointing to another drive, all of them point at the c drive. Can I do a global edit somewhere? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make a global change of Hyperlink addresses?
You can do this with 'find and replace'...
If you have them through formulae then first change to display formulae (by CTRL-`) and then use 'find and replace'... "Rick" wrote: I have a large group of hyperlinks that have changed the base part of their address. Probably when the spreadsheet quit and I had to recover the file. Instead of pointing to another drive, all of them point at the c drive. Can I do a global edit somewhere? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| group workbooks/files to make global changes? | New Users to Excel | |||
| How to make global changes to charts | Charts and Charting in Excel | |||
| Global update hyperlink address | Setting up and Configuration of Excel | |||
| Changing hyperlink addresses (global)? | Excel Worksheet Functions | |||
| global change to document hyperlink root directory | Links and Linking in Excel | |||
Linear Mode
