Hello all,

I have an Excel File that is linked to another one.
EDIT
LINKS
.....

I have the choice between :
Update Now
Open Source
Change Source

How can I know what are exactly the data that are Linked between these
files.

Also, I would like to delete this link. When I try Open Source, I get a
message saying the file is not anymore available !!!

Thanks in advance

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=492153

Herve,

The source path may have changed. The file may still exist but was
moved to a different location. Search your computer for the file using
the search option on the Start menu if you need to restablish the link.
Once you know where it is, open your file, Edit/Links/Change source and
direct the link to the new location.

If you don't care and just want to delete the link, you should also
have a selection called "Break Link". Select this and a pop up will
appear asking you if you are sure you want to do that. Click OK and
the link will be gone.


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=492153

Steve,
Where can I find "Break Link" ?
Thanks


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=492153

Herve,

It should be an option when you go to Edit/Links.

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=492153

Steve,

In Excel Version 2000, I have only :
Update Now
Open Source
Change Source

If there an other way to break this link then ?

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=492153

Herve,

Unfortunately I don't have 2000 but I looked it up and the direction I
gave you should apply to 2000 as well. You have to select the link in
the Source box from Edit/Links. Then maybe it will activate the "Break
Link" option. Again, since I don't have 2000, I can only rely on
microsoft.com, who gives the same direction.


Good Luck!

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=492153

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

herve wrote:

Hello all,

I have an Excel File that is linked to another one.
EDIT
LINKS
....

I have the choice between :
Update Now
Open Source
Change Source

How can I know what are exactly the data that are Linked between these
files.

Also, I would like to delete this link. When I try Open Source, I get a
message saying the file is not anymore available !!!

Thanks in advance

Regards

Herve

--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=492153

--

Dave Peterson