Excel: "Open source file" shortcut? 1

[spartain]

I am working in a workbook that is linked to several other Excel files, and I would like to open the source files quickly. I am aware of 2 ways to open a source file: "Open Source" in the "Links..." window from the "Edit" menu, and using formula auditing ("Trace precedents", double click on the worksheet icon). Is anyone aware of a keyboard shortcut to quickly open the source file linked to a given cell?
Thanks.

 

[GlennUK]

If you have an external link in a cell, and you have Tools/Options/Edit/Edit Directly In Cell unticked, then double-clicking the cell will navigate the link, opening the supporting workbook if necessary.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[spartain]

Thanks!

 

[Gavona]

Nice tip. I was going to untick that option off after I saw this post, but sadly that only seems to work if the external link is the first reference within the cell. So it won't help with:
=al + [external reference] or =vlookup(at,[externalreference],2,0)


Gavin

 

[GlennUK]

Yes, double-click navigation only goes to the first reference in a formula, which on your examples would be al and at. Of course with just having a link ( which is a formula ), the first ( and only ) reference is the external link.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.