ExcelBanter - Excel '02: does it allow source files (linked cells) to be opened.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel '02: does it allow source files (linked cells) to be opened. (https://www.excelbanter.com/excel-discussion-misc-queries/1553-excel-02-does-allow-source-files-linked-cells-opened.html)

Excel '02: does it allow source files (linked cells) to be opened.

I saw someone open a source file by double-clicking on the linked cell, and
then the source file opened automatically. The long way of doing this is
Edit-Links-Open Source. Is this function possible in Excel 2002 - I was
thinking it might be an add-in? Any help would be appreciated!

RAS

Select any cell and right-clickHyperlink

Find a source file to link to from the options presented and OK your way out.

Now just click on the cell and the source file opens.

Gord Dibben Excel MVP

On Wed, 8 Dec 2004 14:49:03 -0800, RAS wrote:

I saw someone open a source file by double-clicking on the linked cell, and
then the source file opened automatically. The long way of doing this is
Edit-Links-Open Source. Is this function possible in Excel 2002 - I was
thinking it might be an add-in? Any help would be appreciated!