Results 1 to 2 of 2
2002-08-03, 17:44 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Edit/Replace in Links (2000 SR-1)
Is there a way to edit the text in links globally? I have copied several worksheets with links in that workbook to another Excel workbook. Those worksheets have links to Excel and Word documents. I can Edit/Links and change the source file, but it then changes the source for the links I have to Word documents too. That I don't want changed, just the links to Excel workbooks.
Thx in advacne
2002-08-05, 01:01 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
Re: Edit/Replace in Links (2000 SR-1)
You could use Edit/Replace to change the old references to the new ones.
If you click on a linked cell in the target worksheet (with the source workbook closed), you'll see that it has a formula containing the full path, workbook and sheet name of the source workbook enclosed in single quotes, followed by the cell reference. Since you only want to change the links to Excel workbooks and not to other files, you just need to make sure that you include the name and extension of the source workbooks in the old & new strings. You'll need to do this on each worksheet in your target workbook.
[MS MVP - Word]