Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit excel pdf hyperlink using find replace
How do I globally change the hyperlinks set up in an excel worksheet - master
file? The hyperlinks have changed folder .pdf to another location when I've separated invoice scanned .pdf files into years. Thus I've broken the hyperlinks & wonder if I can quickly change the file strings to incorporate the additional \Worksheets-year string here before \Worksheets 2005\ Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
edit excel pdf hyperlink using find replace
Have you tried using Find and Replace - highlight the cells with the
hyperlinks in and CTRL-H. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Find & Replace to edit cell references in links | Excel Discussion (Misc queries) | |||
How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
Excel find and replace issue | Excel Discussion (Misc queries) | |||
Find and Replace Hyperlink Contents | Excel Discussion (Misc queries) |