Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Usnig Hyperlinks
I am using Excel XP. I have a workbook with multiple worksheets. Can I use
find and replace to find an entry that appears on multiple sheets and replace it with a hyperlink to another file? |
#2
|
|||
|
|||
Yes,
Example: Select EDIT from the top menu. Then select REPLACE. Put the entry that you want to replace in the 'Find What' box. Put the full name of the file you want to hyperlink to in the 'Replace With' box. You need to put the full name within the Hyperlink function. The Replace With box should have something like... =hyperlink("D:\Temp\MyFile.xls") This will create a hyperlink where the entry once was. HTH, Gary Brown "HandsOnManager" wrote: I am using Excel XP. I have a workbook with multiple worksheets. Can I use find and replace to find an entry that appears on multiple sheets and replace it with a hyperlink to another file? |
#3
|
|||
|
|||
Gary thanks! Now, how can I change the text in the cells and still retain
the hyperlink? "Gary Brown" wrote: Yes, Example: Select EDIT from the top menu. Then select REPLACE. Put the entry that you want to replace in the 'Find What' box. Put the full name of the file you want to hyperlink to in the 'Replace With' box. You need to put the full name within the Hyperlink function. The Replace With box should have something like... =hyperlink("D:\Temp\MyFile.xls") This will create a hyperlink where the entry once was. HTH, Gary Brown "HandsOnManager" wrote: I am using Excel XP. I have a workbook with multiple worksheets. Can I use find and replace to find an entry that appears on multiple sheets and replace it with a hyperlink to another file? |
#4
|
|||
|
|||
Look in help for the hyperlink function
=HYPERLINK("link","Friendly Name") put the text where friendly name is -- Regards, Peo Sjoblom "HandsOnManager" wrote in message ... Gary thanks! Now, how can I change the text in the cells and still retain the hyperlink? "Gary Brown" wrote: Yes, Example: Select EDIT from the top menu. Then select REPLACE. Put the entry that you want to replace in the 'Find What' box. Put the full name of the file you want to hyperlink to in the 'Replace With' box. You need to put the full name within the Hyperlink function. The Replace With box should have something like... =hyperlink("D:\Temp\MyFile.xls") This will create a hyperlink where the entry once was. HTH, Gary Brown "HandsOnManager" wrote: I am using Excel XP. I have a workbook with multiple worksheets. Can I use find and replace to find an entry that appears on multiple sheets and replace it with a hyperlink to another file? |
#5
|
|||
|
|||
Unfortunately now, although the cell appears to be a link, when I click on it
I get an error message "Cannot open the specified file". Any suggestions? "Peo Sjoblom" wrote: Look in help for the hyperlink function =HYPERLINK("link","Friendly Name") put the text where friendly name is -- Regards, Peo Sjoblom "HandsOnManager" wrote in message ... Gary thanks! Now, how can I change the text in the cells and still retain the hyperlink? "Gary Brown" wrote: Yes, Example: Select EDIT from the top menu. Then select REPLACE. Put the entry that you want to replace in the 'Find What' box. Put the full name of the file you want to hyperlink to in the 'Replace With' box. You need to put the full name within the Hyperlink function. The Replace With box should have something like... =hyperlink("D:\Temp\MyFile.xls") This will create a hyperlink where the entry once was. HTH, Gary Brown "HandsOnManager" wrote: I am using Excel XP. I have a workbook with multiple worksheets. Can I use find and replace to find an entry that appears on multiple sheets and replace it with a hyperlink to another file? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with hyperlinks | Excel Discussion (Misc queries) | |||
Can VBA edit hyperlink(s) address | Excel Discussion (Misc queries) | |||
Can 2 different hyperlinks be in the same Excel cell? | Excel Worksheet Functions | |||
hyperlinks and copying a worksheet | Excel Worksheet Functions | |||
up-date hyperlinks in Excel | Excel Worksheet Functions |