How to Update a link within a workbook

[Lynne]

I would like to be able to update the links in a workbook to another tab in
the same workbook. However, the update links function is greyed out when the
links are in the same workbook. (I do not want to use "find and replace" if
I can avoid it).

[Dave Peterson]

Edit|Links means links to other workbooks.

I think Edit|Replace may be the easiest way to go.

Lynne wrote:
>
> I would like to be able to update the links in a workbook to another tab in
> the same workbook. However, the update links function is greyed out when the
> links are in the same workbook. (I do not want to use "find and replace" if
> I can avoid it).

--

Dave Peterson