Microsoft KB Archive/64670

Word 5.50: Inserting Worksheet Three-Dimensional Ranges

PSS ID Number: Q64670 Article last modified on 11-02-1994

5.50

MS-DOS

= SUMMARY =

When attempting to insert a three-dimensional range created within a Lotus 1-2-3 version 3.0 multiple-sheet file with the Insert File command, Word version 5.50 will only insert the data contained in the three-dimensional range one level at a time. The Insert File command must be executed to insert each level of the three-dimensional range into a Word document.

When entering three-dimensional ranges in the Insert File “Range:” field, Word will insert only the data from the range for the first level specified.

Word uses this method to insert three-dimensional ranges so that you can insert all or specific levels of a three-dimensional range into a document. If the file specified in the Insert File “file name:” field is a three-dimensional worksheet, Word will display the following message:

The specified range is 3-dimensional. Only the range on the first sheet will be imported.

To insert each level of a three-dimensional range into a document, perform the following steps:


 * 1) Select the Insert File command.
 * 2) In the “file name:” field, enter the name of the worksheet to insert into the Word document, or highlight the filename in the Files list box.
 * 3) Press ALT+R to move to the “range:” field.
 * 4) Enter the letter that corresponds to the level of the three-dimensional range to insert, then a colon, then the name of the three-dimensional range. The Range list box will display the names of all ranges defined in the worksheet currently highlighted in the Files list box.
 * 5) To create a link between the specified level of the three-dimensional range, in order to easily update the worksheet data, press ALT+L to move to the Link check box, then press the SPACEBAR to place a check in the box.
 * 6) Press ENTER to insert the Range data into the document.

= MORE INFORMATION =

A Lotus 1-2-3 version 3.0 worksheet can contain as many 256 worksheets, with each worksheet in the file assigned a letter from A to IV (the 256th worksheet). A three-dimensional range is a range that spans two or more consecutive worksheets in the same file. However, a three-dimensional range cannot span files.

For example, the range A:A1..B:B2 is a three-dimensional range that contains the contents of cells A:A1, A:A2, A:B1, A:B2, B:A1, B:A2, B:B1, and B:B2 (a 2-cell by 2-cell by 2-cell area).

KBCategory: kbother KBSubcategory: Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1994.