Microsoft KB Archive/63904

Multiplan: “Shapes of Areas Do Not Match” with Xternal Total PSS ID Number: Q63904 Article last modified on 08-28-1990 PSS database name: D_MPlan

4.00 4.01 4.20

MS-DOS

Summary:

The error message “Shapes of areas do not match” may occur if Xternal Total is applied to multiple worksheets listed in the “from sheet:” field and the shapes of the worksheet areas do not match.

If the entire worksheet is specified in the “Name:” field of the Xternal Total menu, the shape of all worksheets must be identical. With multiple worksheets listed in the “from sheet:” field, it is recommended that a specific named range be entered in the “Name:” field rather than accepting the default of r1c1:r4095c255. The message does not occur using the Xternal Total command with one worksheet listed in the “from sheet:” field.

More Information:

To eliminate the error, use the Name command to name the range within each of the worksheets. Make sure that the same name is used within each worksheet and that each range has an identical shape.

This error can be duplicated by the following steps:


 * 1) Create a worksheet and save it out three times. For purposes of this example, name the worksheets x1, x2, and x3.
 * 2) Load worksheet x3.
 * 3) Place a number in the next open column to the right.
 * 4) Save the worksheet.
 * 5) Perform a Transfer Clear All.
 * 6) Run Xternal Total and enter “x1,x2,x3” (without the quotation marks) in the “from sheet:” field.

The error message “Shapes of areas do not match” will appear at the bottom of the screen. Use the Name command within each worksheet to define ranges of identical shape. Enter this name in the “Name:” field of the Xternal Total menu. This procedure will prevent the error from occurring and allow the shape of the entire worksheet to be modified without affecting the Xternal Total command.

Copyright Microsoft Corporation 1990.