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?