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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Excel Files - Shared Server 2
How to create absolue path link to another workbook (Excel 2003) 1
Linked Spreadsheets - Preventing Access to Source Sheet 1
Link 2 Excel files 6
INDEX/MATCH automatic updates while source files are closed 5
Double Click to go to source 1
Linking problems in Excel 2007 2
Linking cells: open source to update values 2

Back
Top