Microsoft KB Archive/20820

External Copy of Noncontiguous Area in Multiplan PSS ID Number: Q20820 Article last modified on 10-17-1990 PSS database name: D_MPlan

1.x 2.x 3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Multiplan versions 1.x allow copying of noncontiguous areas. Multiplan versions 2.x, 3.00, 3.01, 3.02, 3.04, 4.00, 4.01, and 4.20 will not allow you to directly do an External Copy of a noncontiguous area by specifying the noncontiguous cell references in the Name field under External Copy.

In other words, External Copy will fail if you try to type in two separate areas to be copied as a single area (r1c1,r1c3). This is by design. These areas should be copied as individual, contiguous regions.

Workaround
A workaround is to give the noncontiguous areas a single name in the supporting worksheet. Then, use that name in specifying what area to copy from when you are in the Name field under External Copy in the Depending worksheet.

Copyright Microsoft Corporation 1990.