<div>
we can help you write a macro to do so, and associate it with a shortcut key ...
</div>


we can help you write a macro to do so, and associate it with a shortcut key ...

<div>
On the Data tab, click on the Edit Links button, then you can open the source workbook from the list there.
</div>


On the Data tab, click on the Edit Links button, then you can open the source workbook from the list there.

<div>
brothertruffle880,<br />
<br />
Do you need any more information?
</div>


brothertruffle880,

Do you need any more information?

<div>
<div class="content wysiwyg-content">
I have a cell in my current Excel workbook and would like to know if there a quick way to open the workbook whose cell contents are referred to in my cell.<br />
<br />
All I can think of is to press F2, Copy the location of the workbook, and paste it in the address line of a browser, clean up the square brackets and equal signs and then press ENTER.<br />

</div>
</div>


I have a cell in my current Excel workbook and would like to know if there a quick way to open the workbook whose cell contents are referred to in my cell.

All I can think of is to press F2, Copy the location of the workbook, and paste it in the address line of a browser, clean up the square brackets and equal signs and then press ENTER.


Are there SHORTCUTS to open a linked workbook?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.