Removing old File Links

MikeGeno

Board Regular
Joined
Apr 4, 2008
Messages
130
Hello,

I am currently using Excel 2000 at work and we have a lot of old files kicking around that we tend to recycle. I run into a problem many times where the files says there are links to old files that no longer exist and I am unable to break them (No Break Links function in 2000)

Occasionally I am able to a find and root out some cells that reference the old file but most of the time the worksheet has been long deleted that conatined the links and I am stuck with the link message each time it opens.

Any Thoughts?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

c_m

Well-known Member
Joined
May 29, 2008
Messages
836
how about tools-options-calculation tab-dont select "Update remote references"
 
Last edited:
Upvote 0

MikeGeno

Board Regular
Joined
Apr 4, 2008
Messages
130
I tried the first method but it just stopped all links.


Thanks Bowlnhokie, that add-in did the trick wish I had known about that thing a long time ago,
 
Upvote 0

Forum statistics

Threads
1,191,318
Messages
5,985,950
Members
439,991
Latest member
NCWalker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top