Opening Hyperlinks in only one other window

[sjackson330]

Heres the problem. I have several hyperlinks in a workbook that open other Excel documents. Everything works fines, except for each time I click on a Hyperlink it opens another window. Is there a way that when I click on a hyperlink, it opens another window.....but when I toggle back to the orignal document and click another hyperlink, I don't want it to open a "brand new" window, I want it to use the window that I've already opened with the other hyperlink....WHEW!!!

Ultimately I'll only have two windows open at ONE time. 1. My original document with all the hyperlinks and 2. the files that are returned when I click a hyperlink.