I have a WB with two sheets; the first is an index to cells in the second & has a lot of hyperlinks tothe second sheet. I'm trying to edit these hyperlinks but using the method described on this page:
https://www.extendoffice.com/documents/excel/1437-excel-change-multiple-hyperlinks.html

But it just doesn't work. I enter a string that exists in the hyperlink (not the visible text, the actual link) but Kutools can't find anything when either 'Hyperlink' or 'Function' is selected.

Does this function actually work on links between sheets, not external links?