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.
Bookmarks