Google Answers Logo
View Question
Q: Excel links between worksheets in the same workbook ( Answered 5 out of 5 stars,   0 Comments )
Subject: Excel links between worksheets in the same workbook
Category: Computers > Software
Asked by: jalube-ga
List Price: $5.00
Posted: 10 May 2005 16:05 PDT
Expires: 09 Jun 2005 16:05 PDT
Question ID: 520160
How to update a link between worksheets in Excel? i have a link on
SheetA. When I click, it will jump to Sheet3 covered the range of
c1100 to m1121. If I insert few rows on Sheet3, the link on SheetA
will not update. Can you show me how?
Subject: Re: Excel links between worksheets in the same workbook
Answered By: maniac-ga on 10 May 2005 17:50 PDT
Rated:5 out of 5 stars
Hello Jalube,

The easiest way to do this is to define a name for the range of cells
in Sheet3 (c1100:m1121) and use that defined name for the hyperlink.

As an example, I created a new Excel file (with three worksheets) and
did the following steps:
 - entered some sample data in $B$2 through $B$4 on Sheet2
 - selected those three cells
 - used the menu Insert -> Name -> Define... and entered Stuff as the
name of the range
 - on Sheet1, I created two hyperlinks
  o the first to the cells $B$2:$B$4 on Sheet2
  o the second to the defined name Stuff
 - I tested both hyperlinks and they both worked OK
 - on Sheet2 I inserted a row that added a blank cell between the
values on that sheet
 - I tested both hyperlinks and saw the following:
  o the first still points to the cells as orginally defined (as you have seen)
  o the second points to the expanded range, including the blank cell

As long as you add rows (or columns) within the middle of the range,
the defined name will work as expected. If you add a row or column at
the beginning or after the end of the range, the range is not

If you need to add rows at the end (and have some space...), be sure
to define the range to a row / column beyond the last data value. I
usually apply a color (e.g., the light yellow) as a reminder. You can
then insert rows / columns anywhere up to the yellow cells and the
range will adjust automatically.

Please make a clarification request if any part of the answer is
unclear or incomplete.

For more information on defined names in Excel, use the online help
using a phrase like
  define name
and you will have several good references with further explanations.

jalube-ga rated this answer:5 out of 5 stars and gave an additional tip of: $1.00

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy