Removing Links - Is there a fast way to remove multiple links?

**FLSnuffy** · 07-12-2012, 10:33 AM

Often 10+ links are used in multiple tabs of a revenue projection spreadsheet. The links have to be broken when the individual tabs are copied and attached as supporting documents. Non-excel users are distracted by the "update links" message, so the links have to be removed at this point.

Is there are quick way to local and break links in the tab copies? I tried the "Insert -> Find" suggestion and it did not highlight the links.

Much appreciated.

PS (Added later) I can locate the links by selecting "Formulas" under the "Tools -> Options" but that takes time, I was hoping for a quicker way to locate & break the links.

**FLSnuffy** · 07-16-2012, 02:09 PM

I am looking for an alternative that will leave the other formulas in tact, so copying the tab and pasting as formatted values is not an attractive option.

**mubashir aziz** · 07-17-2012, 05:57 AM

in Excel 2003 you can delete these links thru Edit-->Links and in Excel 2007 Office icon -->Prepare -->Edit links to files .....

**FLSnuffy** · 07-18-2012, 10:31 AM

Thank you for the suggestion. I use that option, but often have 30+ links to the same file (different cells) that take 30+ clicks to remove links.

Files are used to project various revenues, then the individual tabs are separated and attached as support for the projection. Links need to be removed so approvers do not have to update links when they open the file.

When I open a file, I am given the option of updating or not updating links, and if I choose update the option to break individual links is offered.

The quickest way I have found so far has been to show formulas under Tools - Options and then look for the individual links, then copy and paste value & format.

There may be no easy way to resolve this.

Thank you again for your suggestion.

Snuff