Excel Hyperlink

[hnmurugan]

Hi all,

Would appreciate if you any of you can share your knowledge on below. Some of our users are facing a strange issue with excel 2007. The scenario is,

Summary.xlsx

A1 - hyperlink to template1.xlsx

A2 - hyperlink to template2. xlsx

A3 - hyperlink to template1A.xlsx where it was created using save as function from template1.xlsx

A4 - hyperlink to template2A. xlsx where it was created using save as function from template2.xlsx

note: all the templatexx.xlsx files in the same folder as summary.xlsx (network share)

The problem occurs when try to open hyperlink in A3 where it is opening the template1.xlsx instead of template1A.xlsx. I have ruled out the possibility of user hyper linked to a wrong file as the text description of the link in A3 clearly states as template1A.xlsx.

Regards

Harry

Edited September 15, 2011 by hnmurugan