Opening a Hyperlink in the Same Excel Book instead of a New Excel Book

I've made hyperlinks in my Excel spreadsheet. The hyperlinks are to other Excel spreadsheets in different documents. When I click on the links, the link is opened in a new Excel document. Is there anyway that I can make it so when I click on the links, they opened up as new sheets in the same document instead of an intirely new document?

Hello lizeski,

Welcome to the Forum!

If your hyperlink is to another worksheet in another workbook then Excel will open the destination workbook. This what hyperlinks do. Did you want to copy the destination worksheet into the source workbook, make changes, and put save it back to the destination?

Sincerely,
Leith Ross

I am trying to make a template that does calculations with whichever link is clicked. I want to have a list of hyperlinks and if you click on one of them, then it comes into the document and the calculations are made on the other sheets in the same workbook with fomulas that are already set up. If I have to do it individually, it's about a thousand different spreadsheets of numbers.

Hello lizeski,

If you are wanting to calculate worksheet data in your template workbook using formulas from a worksheet in another workbook, I have no idea how to do it. It might be possible with macros, but would depend a lot on the workbook formats.

Sincerely,
Leith Ross

Thanks for your help anyway!