Moving hyperlinks from 2003 to 2007

[Miki]

I have generated an excel worksheet in 2003 with a list that every row has
one cell with hyperlink to another sheet within the same workbook. In the
second sheet I have named each cell/box with TNxx (xx represents sequential
number). Then, in each box I have added a long text. It was working fine in
2003, and my lists grew up to hundreds of rows.
When I have moved to Excel 2007, I got an error message that “TNxx†is a
reference to a cell in a sheet (I assume that Excel 2003 did not supported
this range of columns), and got recommendation to fix it automatically and it
does not work.
Currently I am saving the file in 97-2003 format, but I would like to move
to 2007.
Do you have any suggestion how to solve this hyperlink problem?

 

[Dave Peterson]

If you open the workbook in xl2007, don't you get the offer to change these
names (prefacing them with an underscore, like: _TN99).

If that's true, then ...

If you used the =hyperlink() formula, maybe you can select that range and do an
Edit|Replace (or xl2007 equivalent).

If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But
the good news is David McRitchie has done most of it for you:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)