How do I change the links in Excel at one batch?
in [General]
|
Prev: pet food bank needs template for organization of customers
Next: Does anybody know why these two Excel files must be open in the same process?
From: LunaMoon on 23 Apr 2010 19:04 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!
From: Dave Peterson on 23 Apr 2010 19:59
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 here: 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 |