software

I've got a spreadsheet that has been saved year over year to the new
year. Although links to certain files are no longer within the body of
the current file, when I go to editgt;links, all of the old files show
there as linked to (going back to 1998). I would like the editgt;links
to only show the files that the workbook is currently linked to. I know
in Excel 2002 there is a function that will quot;break linksquot; but I'm using
Excel 2000 and can't seem to get rid of these many files. Any help would
be appreciated--

Thanks,
Amy--
amyp
------------------------------------------------------------------------
amyp's Profile: www.excelforum.com/member.php...oamp;userid=32489
View this thread: www.excelforum.com/showthread...hreadid=522773Edit, Links shows only the files to which there are current links. So these
'old' links still exist. To find and delete them you should get the
FindLink utility found he

www.oaltd.co.uk/MVP/Default.htm

--
Jim
quot;amypquot; gt; wrote in message
...
|
| I've got a spreadsheet that has been saved year over year to the new
| year. Although links to certain files are no longer within the body of
| the current file, when I go to editgt;links, all of the old files show
| there as linked to (going back to 1998). I would like the editgt;links
| to only show the files that the workbook is currently linked to. I know
| in Excel 2002 there is a function that will quot;break linksquot; but I'm using
| Excel 2000 and can't seem to get rid of these many files. Any help would
| be appreciated--
|
| Thanks,
| Amy
|
|
| --
| amyp
| ------------------------------------------------------------------------
| amyp's Profile:
www.excelforum.com/member.php...oamp;userid=32489
| View this thread: www.excelforum.com/showthread...hreadid=522773
|

Thanks Jim-
Does that utility only delete the links from the workbook that you have
open or any workbook on your system?

THanks---
amyp
------------------------------------------------------------------------
amyp's Profile: www.excelforum.com/member.php...oamp;userid=32489
View this thread: www.excelforum.com/showthread...hreadid=522798It looks at the open workbook.

amyp wrote:
gt;
gt; Thanks Jim-
gt; Does that utility only delete the links from the workbook that you have
gt; open or any workbook on your system?
gt;
gt; THanks-
gt;
gt; --
gt; amyp
gt; ------------------------------------------------------------------------
gt; amyp's Profile: www.excelforum.com/member.php...oamp;userid=32489
gt; View this thread: www.excelforum.com/showthread...hreadid=522798

--

Dave Peterson