ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2000 breaking links (https://www.excelbanter.com/excel-discussion-misc-queries/144702-excel-2000-breaking-links.html)

awhyswoman

Excel 2000 breaking links
 
I am using Excel 2000 and have a lot of links to files that no longer exist
or have been moved. When I click Edit, Links and select the links I do not
get an option to break the link - only to Update Now, Open Source or Change
Source. Any ideas?

Thank you.

Dave Peterson

Excel 2000 breaking links
 
I think the the break link option was added in xl2002. So maybe you could open
the file on a pc with xl2002+.

Or

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

awhyswoman wrote:

I am using Excel 2000 and have a lot of links to files that no longer exist
or have been moved. When I click Edit, Links and select the links I do not
get an option to break the link - only to Update Now, Open Source or Change
Source. Any ideas?

Thank you.


--

Dave Peterson

awhyswoman

Excel 2000 breaking links
 
WOW! That FinkLink and many of the other programs on that site are wonderful!
Thank you.

"Dave Peterson" wrote:

I think the the break link option was added in xl2002. So maybe you could open
the file on a pc with xl2002+.

Or

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

awhyswoman wrote:

I am using Excel 2000 and have a lot of links to files that no longer exist
or have been moved. When I click Edit, Links and select the links I do not
get an option to break the link - only to Update Now, Open Source or Change
Source. Any ideas?

Thank you.


--

Dave Peterson


Dave Peterson

Excel 2000 breaking links
 
There are a lot of smart people who share utilities like this:

You may want to visit this site:
http://www.oaltd.co.uk/mvp

And download Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager (NameManager.Zip).

(among others!)


awhyswoman wrote:

WOW! That FinkLink and many of the other programs on that site are wonderful!
Thank you.

"Dave Peterson" wrote:

I think the the break link option was added in xl2002. So maybe you could open
the file on a pc with xl2002+.

Or

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

awhyswoman wrote:

I am using Excel 2000 and have a lot of links to files that no longer exist
or have been moved. When I click Edit, Links and select the links I do not
get an option to break the link - only to Update Now, Open Source or Change
Source. Any ideas?

Thank you.


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com