I'm having this exact same problem using Excel 2003 and cannot find any
information on how to resolve it.

I have a workbook I use for classroom attendance and every time I make any
edits to the template spreadsheet and then copy that spreadsheet to the other
tabs I have to update the links for each class by hand (each class is in a
separate tab spreadsheet). I want to be able to set up one class as a
template and then duplicate/copy that to create the other classes, but it is
a real pain having to update the reference for each hyperlink on each page
each time, because the hyperlinks always reference the original template
spreadsheet.

Any help on this would save me hours of work - the template spreadsheet has
about 60 links and right now I have to update an additional 180 links each
time I make the copies. Thanks!

(PS If this is normal functionality for Excel 2003, is it improved in the
new version of Excel?)

"drsilicone" wrote:

I'm having a problem with this solution -- it seems the hyperlinks are too
much when I'm trying to duplicate pages and make changes -- I need to make
links that are absolute within the sheet itself and don't refer to
files\sheets

ie. I want a link that points specifically to a cell within the sheet but is
not relative to any location. Also I want to be able to make a macro that
allows me to create several links on a page so that I can apply that macro to
many other pages -- this won't work with the way 'hyperlinks' seem to work in
excel - can anyone help?