Microsoft KB Archive/894030

= You cannot insert a complete Excel for Mac worksheet into a Word for Mac document =

Article ID: 894030

Article Last Modified on 3/8/2005

-

APPLIES TO


 * Microsoft Word 2004 for Mac
 * Microsoft Word X for Mac
 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac

-





SYMPTOMS
When you insert a Microsoft Excel for Mac worksheet into a Microsoft Word for Mac document, only five columns and ten rows of the worksheet appear in the Word for Mac document. In the Word for Mac document, if you try to make the worksheet larger by using the drag handle, the worksheet grows larger but it does not reveal any new rows or columns.



CAUSE
This issue occurs if you click Insert Excel Spreadsheet on the Standard toolbar to insert the Excel for Mac worksheet.



RESOLUTION
To work around this issue, you must create the Excel for Mac worksheet as a separate workbook, and then insert the workbook into the Word for Mac document either as a file or as an object.

Note For both methods, you must have an existing Excel for Mac workbook saved on your hard disk drive.

Insert the workbook as a file

 * 1) In Word for Mac, click View, and then click Page Layout.
 * 2) On the Insert menu, click File.
 * 3) Locate and then select the Excel for Mac workbook.
 * 4) Click Insert.
 * 5) Select the worksheet that you want to insert into the document from the Open Document in Workbook list.
 * 6) If you want a specific cell range from the worksheet, type the range in the Cell Range text box by using the  :  syntax.

For example, to insert the first ten columns and the first eleven rows, you would type A1:I11. Otherwise, leave the text &quot;Entire Worksheet&quot; in the Cell Range box.
 * 1) Click OK.

The worksheet is inserted as a Word table into the Word for Mac document.

Insert the workbook as an object
 In Word for Mac, click View, and then click Page Layout. On the Insert menu, click Object. Click From File. Locate and then select the Excel for Mac workbook. Click Insert. If the worksheet is larger than the page width of the document, follow these steps: <ol style="list-style-type: lower-alpha;"> On the Format menu, click Object.</li> Click the Size tab.</li> Under Scale, type a percentage value in the Height and Width text boxes for the size you want the worksheet to be.</li> Click OK.</li></ol> </li></ol>

Additional query words: WDX WD2004 XL2004 XLX Macintosh

Keywords: kbtshoot kbprb KB894030

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.