If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change the links in Excel at one batch?
Hi all, Good day! Please help me with the following issue: How do I do the following in Excel? Suppose in an Excel sheet there are lots of links, linking the cell to other sheets, There are millions of such links, how do I change the links to another sheet name at one batch? I hope there is a "Find/Replace" for these links? Thanks a lot! |
#2
|
|||
|
|||
How do I change the links in Excel at one batch?
Saved from a previous post:
If you used Insert|Hyperlink, then you've noticed that edit|replace won't touch those hyperlink addresses. If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But the good news is David McRitchie has done most of it for you: http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) LunaMoon wrote: Hi all, Good day! Please help me with the following issue: How do I do the following in Excel? Suppose in an Excel sheet there are lots of links, linking the cell to other sheets, There are millions of such links, how do I change the links to another sheet name at one batch? I hope there is a "Find/Replace" for these links? Thanks a lot! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|