Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default File path of external link changed


Hi all,

I have an excel file (say, c:\Master.xls) that link externally to other
files (say, C:\xyz\OtherFile.xls). We need to send (via email)
Master.xls to someone for editing (but OtherFile.xls is not send
together). When the file is sent back to me, the link to OtherFile.xls
changed (instead of C:\xyz\OtherFile.xls, it becomes OtherFile.xls
only), thus making all the calculation failed.

(I hope I have make the problem clear.) ^^

Is there any way that we can send the Master.xls file to the others for
editing but do not change the external link in the worksheet?

Thanks




--
ramram49
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 329
Default File path of external link changed

Hi ramram49,

You can correct the links in the returned workbook via Edit|Links.

Cheers

--
macropod
[MVP - Microsoft Word]


"ramram49" wrote in message
...

Hi all,

I have an excel file (say, c:\Master.xls) that link externally to other
files (say, C:\xyz\OtherFile.xls). We need to send (via email)
Master.xls to someone for editing (but OtherFile.xls is not send
together). When the file is sent back to me, the link to OtherFile.xls
changed (instead of C:\xyz\OtherFile.xls, it becomes OtherFile.xls
only), thus making all the calculation failed.

(I hope I have make the problem clear.) ^^

Is there any way that we can send the Master.xls file to the others for
editing but do not change the external link in the worksheet?

Thanks




--
ramram49



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
Pivot Table external XLS file source change and GETPIVOTDATA refresh mbobro Excel Discussion (Misc queries) 0 July 8th 06 12:45 PM
How can I link external excel file cell formats? Peter Excel Worksheet Functions 0 June 27th 06 05:23 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 08:45 AM
How do link to a remote field but use the path from a stored field Michael T. Excel Discussion (Misc queries) 1 December 10th 04 12:18 AM


All times are GMT +1. The time now is 12:14 AM.

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

About Us

"It's about Microsoft Excel"