This is driving me nuts!!
It seems that anytime the =HYPERLINK() function in Excel (2007) has been used to create a link to a different workbook, clicking the link not only activates the target workbook but also moves it into exactly the same location on the screen already occupied by the workbook containing the link. This appears to be the case regardless of whether the two workbooks are opened in a single Excel instance or opened in separate instances.
The net result of course is that any advantage gained by positioning workbooks side-by-side to view them together is lost. In other words, any desired benefit of using hyperlinks to jump quickly and easily between two workbooks, is lost since the target workbook does not remain fixed in its original position.
I suppose there are some occasions when one would want the target to move to the same location and essentially replace the initial worksheet (the one containing the link) but it seems MS would think to make that optional rather than the way it behaves in all cases.
Any suggestions on how to eliminate the window movement when using =HYPERLINK() would be very greatly appreciated!