Microsoft KB Archive/23020

Merging Spreadsheets in Multiplan PSS ID Number: Q23020 Article last modified on 06-29-1989 PSS database name: D_MPlan

2.x 3.x 4.00 4.01

MS-DOS

Summary:

To merge spreadsheets together into the same spreadsheet, the spreadsheet you want to merge in must be in SYLK (Symbolic Link) file format.

With the main spreadsheet on the screen and with the Transfer Options command set to Symbolic, execute the Transfer Load command. However, if you have values in the same cells in both worksheets, the corresponding value in the initial spreadsheet will be overwritten.

In other words, if you have a value in R1C1 of both the spreadsheet on the screen and the spreadsheet you want to merge in, the value from the spreadsheet you bring in will overwrite the value currently in R1C1. Therefore, make sure the spreadsheet you merge in has information only in cells that are not used in the current spreadsheet.

Copyright Microsoft Corporation 1989.