Microsoft KB Archive/68592

Word: Importing a Microsoft Works Spreadsheet Range

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

5.00 5.50

MS-DOS

= SUMMARY =

Following the instructions in the “Using Microsoft Word” manual to import a Microsoft Works spreadsheet range returns the error “The Range is not Valid” (Word 5.50) or “Not a Valid Range” (Word 5.00). Using any of the recommended formats as specified on page 560 of the Word 5.50 manual or on page 540 of the Word 5.00 manual returns this error.

To import a Works spreadsheet area into Microsoft Word, do the following:


 * 1) Open the spreadsheet file in Works and assign a name to the spreadsheet area to be linked. In Works version 2.00, select the area and choose Range Name from the Edit menu to define a range (use the Edit Name command in Works 1.00 and 1.05).
 * 2) In Word 5.00, use the Library Link Spreadsheet command and type in the path and spreadsheet filename after “filename:”. Beside the “area:”, field enter the area name specified in Works. Only the area specified by the area name will be linked into the Word document.
 * 3) In Word 5.50, choose File from the Insert menu and type the appropriate path and filename under “Filename”. Enter the spreadsheet area name in the Range box and choose Link. Only the area specified by the area name in Microsoft Works will be inserted into the Word document.

When you are importing an entire spreadsheet from Microsoft Works, you do not need to indicate a range/area name.

KBCategory: kbother KBSubcategory: Additional reference words:

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