Hyperlinks Changing on their own

[Larry R]

Ok, I haven't been drinking...This has been verified on multiple
computers, with Office 2000 & 2003.

I have a worksheet that contains hyperlinks to other worksheets within
the same workbook.

When I open the workbook, the hyperlinks are correct. If I do NOTHING
and save, the hyperlinks now point to some other page in the
workbook.

There are no marcros in this workbook, and it is fairly small ( 5
worksheets ) .

Again, I made no changes ( not even typing in a cell or clicking the
hyperlink ) and they changed. I even tried Save as Excel97 and the
same thing happened.

Any ideas out there?

Larry

 

[Anne Troy]

Can you give us an example of exactly HOW at least one of these changed?
I.e., what was the hyperlink BEFORE and what did it change to?
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[Larry R]

Before: file:///c:\documents and settings\username\my documents
\excelworkbook.xls-SheetName2!A4

After: file:///c:\documents and settings\username\my documents
\excelworkbook.xls-SheetName1!A4

Note the SheetName1

 

[Dave Peterson]

If the links are pointing to a location within the same workbook, why not just
point to that location--drop the drive, path, filename.

Insert Hyperlink|Place in this document.

Personally, I like the =hyperlink() worksheet function. It reacts nicely to
insertion/deletions of rows/columns as well as renaming sheets.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

 

[Larry R]

The worksheet is actually built in code using the Aspose.Cells
product.

The hyperlinks that are inserted have the format of 'Sheet2!A4'. The
file name isn't included.

Thanks for the tip on the function. I'll check it out!

Larry