I have an Excel workbook with a number of sheets within it - the first sheet
is a summary of the data contained in the subsequent sheets and contains
hyperlinks to cell references in each of those sheets. My problem is that
when I ad a row to one of the detail sheets, the hyperlink in the summary
sheet doesn't automatically update itself to reference the new cell address.
Is there any way that I can do this?

Consider assigning a Named Range to the destination cells. When you:
Insert Hyperlink... To a place in this document
The Name will be available.

This destination will adjust as rows/columns are added/removed

Also the =HYPERLINK() function can reference the Names as well.
--
Gary''s Student - gsnu200811


"Mike McLellan" wrote:

I have an Excel workbook with a number of sheets within it - the first sheet
is a summary of the data contained in the subsequent sheets and contains
hyperlinks to cell references in each of those sheets. My problem is that
when I ad a row to one of the detail sheets, the hyperlink in the summary
sheet doesn't automatically update itself to reference the new cell address.
Is there any way that I can do this?