Prev: Printing Large Posters 3' x 4'
Next: how do you show the status bar if you accidently hide it?
From: LA Horowitz on 31 Mar 2010 14:40
I have links in sheet C that link to sheet B but now I need them to link to
sheet A instead. Is there an easy way to change all the references in sheet
C? or do I have to manually change them? I found help on changing the
source workbook but I can't find anything about changing links to different
worksheets in the same workbook. Thank you.
--
LA Horowitz
From: Gord Dibben on 31 Mar 2010 15:02
There is no Edit>Links for internal links as there is for external links.

A simple Edit>Replace comes to mind as an easy method.

What: SheetC

With: SheetA

Options>Lookin>Formulas.


Gord Dibben MS Excel MVP


On Wed, 31 Mar 2010 11:40:02 -0700, LA Horowitz
<LAHorowitz(a)discussions.microsoft.com> wrote:

>I have links in sheet C that link to sheet B but now I need them to link to
>sheet A instead. Is there an easy way to change all the references in sheet
>C? or do I have to manually change them? I found help on changing the
>source workbook but I can't find anything about changing links to different
>worksheets in the same workbook. Thank you.

From: tompl on 31 Mar 2010 15:23
Use the search and replace proceedure to search for sheet B and replace with
sheet A.

Tom

"LA Horowitz" wrote:

> I have links in sheet C that link to sheet B but now I need them to link to
> sheet A instead. Is there an easy way to change all the references in sheet
> C? or do I have to manually change them? I found help on changing the
> source workbook but I can't find anything about changing links to different
> worksheets in the same workbook. Thank you.
> --
> LA Horowitz
 | 
Pages: 1
Prev: Printing Large Posters 3' x 4'
Next: how do you show the status bar if you accidently hide it?