Does anyone have a way to programmatically 'break' a link? The need arises when an Excel-based report is created that has multiple links to other workbooks containing current standards. The document is 'signed off' and the information that it contains in the form of links needs to be broken to represent a true history of the standard at the time the document was created and it does not need to have an auditing path shown.
I have explored 'ActiveWorkbook.LinkFormat' but this only referred to shape objects.
Any other suggestions? TIA, Leigh