Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 15th 06, 07:02 PM posted to microsoft.public.excel.misc
amyp
 
Posts: n/a
Default Breaking Links in Excel 2000


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 editlinks, all of the old files show
there as linked to (going back to 1998). I would like the editlinks
to only show the files that the workbook is currently linked to. I know
in Excel 2002+ there is a function that will "break links" 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: http://www.excelforum.com/member.php...o&userid=32489
View this thread: http://www.excelforum.com/showthread...hreadid=522773


  #2   Report Post  
Old March 15th 06, 07:38 PM posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default Breaking Links in Excel 2000

Edit, 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

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

--
Jim
"amyp" 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 editlinks, all of the old files show
| there as linked to (going back to 1998). I would like the editlinks
| to only show the files that the workbook is currently linked to. I know
| in Excel 2002+ there is a function that will "break links" 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:
http://www.excelforum.com/member.php...o&userid=32489
| View this thread: http://www.excelforum.com/showthread...hreadid=522773
|


  #3   Report Post  
Old March 15th 06, 08:03 PM posted to microsoft.public.excel.misc
amyp
 
Posts: n/a
Default Breaking Links in Excel 2000


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: http://www.excelforum.com/member.php...o&userid=32489
View this thread: http://www.excelforum.com/showthread...hreadid=522798

  #4   Report Post  
Old March 15th 06, 09:29 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Breaking Links in Excel 2000

It looks at the open workbook.

amyp wrote:

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: http://www.excelforum.com/member.php...o&userid=32489
View this thread: http://www.excelforum.com/showthread...hreadid=522798


--

Dave Peterson


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
how do I run excel 4.0 macros on excel 2000 RodolfoDallas Excel Discussion (Misc queries) 1 March 12th 06 03:14 AM
Excel 5 and Excel 2000 question. Naveen Mukkelli Excel Discussion (Misc queries) 1 March 3rd 06 09:05 AM
other systems detecting excel 4.0 if excel 2000 is installed Tristan_Flynn Setting up and Configuration of Excel 0 January 18th 05 06:55 PM
How do I Break links Using Excel 2000 DaddyMan Excel Discussion (Misc queries) 1 December 9th 04 10:18 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017