Hi,

I have an excel summary document that has hyperlinks to various other documents - is there a way to use these hyperlinks so that when you click the hyper link it doesn't open a new document in a new sheet, what I need is for the original summary sheet to be replaced by the document opened with the hyperlink.

By doing this only one excel document will be open at any given time - I will then do a "return" link to go back to the summary sheet.