Microsoft KB Archive/23419

Method for Dissolving External Links PSS ID Number: Q23419 Article last modified on 06-29-1987 PSS database name: D_MPlan

3.xx

MS-DOS

Question: I have a worksheet with cells that were originally copied from other worksheets with the “linked” option set to yes. I have deleted all the supporting files. I would like to break the links in the dependent file without modifying individual cells in the worksheet. What method do you recommend?

Response: External links can be dissolved by saving the dependent worksheet in the SYLK file format (set the Transfer Options to Symbolic and issue the Transfer Save command). Then, load the file into a word processor (it will be recognized as an ASCII file) and delete the records marked with “NE” (located near the end of the SYLK file). This will break the link.

Copyright Microsoft Corporation 1987.