Good day;
Excel 2003 - Inserted-Hyperlink paths problems.
1. Many workbooks with multi worksheets with 4,000+ 'relative' hyperlinks, created with Insert-Hyperlink... in Excel2000 and 2003. Same relative network paths problems as in so many other posts.
.
Need tool/macro to automate (automagically) convert/copy each of the existing Hyperlinks' VALUE (which still displays the absolute paths, thankfully)
into a new =hyperlink() formula for each.
.
In most of the spreadsheet / workbooks, 99% of the old hyperlinks are in column 'U'.
Would prefer the new =Hyperlink formula output to go in column V (same row)...just in case.
.
Be great to retain the same value into the new displayed text/Hyperlink as well. (While removing the old useless Hyperlink addresses)
.
I keep reading that the path of Hyperlink-formulas are, and do remain, absolute - which is what I need.
.
Looked at a few 3rd party tools, but they only do bulk change on same types (update either Values or, Formulas, but no automation of the conversion needed).
.
2. From now on, for new Inserted-Hyperlinks, how could sense the new added hyperlinks only - so a macro triggered by ChangeWorkSheet , or CloseWorkbook(!) automatically update only those new inserted-hyperlinks to =Hyperlink formulas ? (So it's faster than checking ALL the many worksheets' cells every time...) This way, can continue inserting hyperlinks the easy way... and the macro would correct them rapidly.
.
Sorry if long-winded - kind of urgent, so hope you have all needed details in the above.
Thank you.