I work quite a lot with XL workbooks containing many sheets with hyperlinks linking the sheets. I now have many word docs which I need to create hyperlinks to from within my XL workbook sheets. The problem is that when I save as... the hyperlink does not update its link with the new file name so I always get linkeg back to the original link. This does not happen when I work all within the same XL workbook.
What should I do? Can I insert my word docs as sheets in my XL workbook>?
This thread is now locked and can not be replied to.