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

R

RAS

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!
 
G

Gord Dibben

RAS

Select any cell and right-click>Hyperlink

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
 
Top