Removing Old links in excel

Geordie

Board Regular
Joined
Oct 16, 2006
Messages
143
Hi all,

Ive searched the forum for answers to this one but couldn't see anything!

I have inherited some excel spreadsheets that have several tabs of data and several links to other excel spreadhseets that cannot be found.

Rather than just break these links I want to find out which cells are currently referencing these "old" spreadhseets. (Then I cant decide if the data should be hardcoded or re-linked elsewhere)

Does anyone have an easy wasy to do this without looking into each cell?!?!!?

Thanks in advance
Mandy
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Hi & Welcome

Dominic B's add in has this facility

http://www.dom-and-lis.co.uk/

Download & install the add in, then from the new menu (Ultimate)

Cells > Find & Remove Links

It will show you all the links & ask if they are to be deleted

HTH
 

Geordie

Board Regular
Joined
Oct 16, 2006
Messages
143
That web-site looks good - But I cant download .exe files onto my work PC...

I'll maybe drop them an email for the code if possible!

Thanks anyway...

M
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
That web-site looks good - But I cant download .exe files onto my work PC...

I'll maybe drop them an email for the code if possible!

Thanks anyway...

M

DominicB may be on here later
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good afternoon Geordie

I’m actually part way through updating the links utility at the moment. It will now list all links in a listbox, output the location, value and underlying (linky type) formulae to a seperate workbook, select (auto highlight) links, remove all links in a worksheet or all links in a workbook.

The bad news is this hasn’t made it to the add-in yet. The good news is it’s just a macro from a workbook and will can be called from any other open file. If you want to try this send me a PM with your e-mail address.

BTW, you don’t have to download it as an .exe file you can also download it as a .zip file – just follow the appropriate link, but I can e-mail to you as a series of files or an archive if you’re struggling to download it.

HTH

DominicB
 

Forum statistics

Threads
1,141,678
Messages
5,707,782
Members
421,527
Latest member
Tamiwsw

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