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,
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.
Edited by hnmurugan, 14 September 2011 - 07:40 PM.