Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RAS
 
Posts: n/a
Default 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!
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
How to open 123 files with excel Jeff B 813 Excel Discussion (Misc queries) 3 December 8th 04 09:11 PM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM
Why does Excel saves all my files as temporary files? Arija Excel Discussion (Misc queries) 2 December 7th 04 11:38 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"