Microsoft KB Archive/31017

Part of External List Is Lost in Sylk File PSS ID Number: Q31017 Article last modified on 01-10-1989 PSS database name: D_MPlan

3.x

MS-DOS

Summary: When the supporting worksheet is saved as a Sylk file, the part of the eXternal List that shows which worksheets are “Dependent” upon this worksheet is lost. This occurs because the Sylk file does not contain a record for holding this information. If you want the complete eXternal List back, you can execute the following steps:


 * 1) Load the dependent worksheet.
 * 2) Save it as a Sylk file by setting the Transfer Options to Symbolic.
 * 3) Reload the file (Transfer Options must still be set to Symbolic).
 * 4) Change the Transfer Options to Normal and save again. This time the file will have the regular Multiplan file format as well as rewrite the dependencies into the spreadsheet.

The list for the supporting worksheet should also be rebuilt by this process.

Copyright Microsoft Corporation 1989.