PC Review


Reply
Thread Tools Rate Thread

How can I email 2 linked files without losing the links?

 
 
Emily Ladywell
Guest
Posts: n/a
 
      4th Apr 2008
I want to email several excel files to a colleague. The files are linked but
they'll lose the link if I email them. I don't want her to have to 'Update
Links' as it will take forever!
 
Reply With Quote
 
 
 
 
Gordon
Guest
Posts: n/a
 
      4th Apr 2008
"Emily Ladywell" <Emily (E-Mail Removed)> wrote in message
news:7554721A-4FE9-4726-9527-(E-Mail Removed)...
>I want to email several excel files to a colleague. The files are linked
>but
> they'll lose the link if I email them. I don't want her to have to 'Update
> Links' as it will take forever!



The links will automatically change, if your recipient saves the files to
her HDD. (At least they do in Excel 2007, just tried it.)

 
Reply With Quote
 
Emily Ladywell
Guest
Posts: n/a
 
      4th Apr 2008
Thanks, but it's just Excel 2002 so I don't think it works for us.

What is an HDD anyway?

"Gordon" wrote:

> "Emily Ladywell" <Emily (E-Mail Removed)> wrote in message
> news:7554721A-4FE9-4726-9527-(E-Mail Removed)...
> >I want to email several excel files to a colleague. The files are linked
> >but
> > they'll lose the link if I email them. I don't want her to have to 'Update
> > Links' as it will take forever!

>
>
> The links will automatically change, if your recipient saves the files to
> her HDD. (At least they do in Excel 2007, just tried it.)
>
>

 
Reply With Quote
 
AliasJ
Guest
Posts: n/a
 
      4th Apr 2008
hard disk drive

Is the recipient saving the files to a location on the HDD. Yes, when
they come in from Outlook, they are on the HDD, but it is basically a
temporary folder. Try having her save the two files in their own
folder, and try opening from there.
 
Reply With Quote
 
AliasJ
Guest
Posts: n/a
 
      4th Apr 2008
Wait, that is a silly idea -- the links use a full file/UNC path, not
a relative one.

Well... you could have your recipient recreate the file structure in
which your xls are stored. It's a dumb solution, but it should work.

If your workbooks are in c:\documents and settings\Emily\My Documents
\Excel
your recipient could create \Emily\My Documents\Excel in her c:
\documents and settings folder (even though "Emily" is not a user on
the machine, and put the files in there.

Of course, depending on the path, she may need to have Administrator
privileges on her machine.
 
Reply With Quote
 
Emily Ladywell
Guest
Posts: n/a
 
      7th Apr 2008
I tried zipping the folder and that seems to be working when I've sent it
internally, but if it doesn't work I'll try your idea. Thanks for the
suggestion!

"AliasJ" wrote:

> Wait, that is a silly idea -- the links use a full file/UNC path, not
> a relative one.
>
> Well... you could have your recipient recreate the file structure in
> which your xls are stored. It's a dumb solution, but it should work.
>
> If your workbooks are in c:\documents and settings\Emily\My Documents
> \Excel
> your recipient could create \Emily\My Documents\Excel in her c:
> \documents and settings folder (even though "Emily" is not a user on
> the machine, and put the files in there.
>
> Of course, depending on the path, she may need to have Administrator
> privileges on her machine.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing files, links and losing my mind. =?Utf-8?B?ZGF2ZTk0NTgz?= Windows XP Help 1 19th May 2007 01:55 PM
HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS CAPTGNVR Microsoft Excel Programming 2 8th Feb 2007 07:13 PM
fast way to change links when moving two linked files. =?Utf-8?B?Z29zaGF3aw==?= Microsoft Word Document Management 1 9th Feb 2006 12:25 PM
Linked files - losing links when moving files =?Utf-8?B?VGhpYmF1dA==?= Microsoft Powerpoint 2 11th Oct 2005 06:25 PM
Losing links to mail merge data source and linked pictures G Walker Microsoft Word Document Management 0 14th Oct 2003 04:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:06 PM.