XL97: Excel Objects Appear Truncated

• Microsoft Excel 97 for Windows
• Microsoft Office 97 for Windows

SYMPTOMS

When you insert a Microsoft Excel object into any program, such as Microsoft PowerPoint or Wordpad, portions of the object may be cut off. Specifically, the right-most and bottom portions may be missing.

In addition, when you edit an embedded Excel object on Microsoft Windows NT, the embedded object may become larger, and the right-most and bottom portions may be missing.

CAUSE

This behavior is caused by a design limitation in the size of a Windows metafile. This design is to prevent overflow in the metafile size. The size of this metafile is more accurately defined in Windows NT than in Windows 95 or Windows 98; therefore, objects embedded in Windows 95 and Windows 98 may exhibit this behavior when edited in a Windows NT environment.

WORKAROUND

To work around this limitation, use one of the following methods.

NOTE: While these examples are written specifically for Excel and PowerPoint, the general principals apply to Excel and Microsoft Word or Excel and any other program that exhibits this behavior.

Workaround 1: Reduce Font and Cell Sizes

1. Right-click the truncated object and click Open Worksheet Object.



2. Select the entire range of the spreadsheet that you would like to alter. If the object is a chart, please see the following article in the Microsoft Knowledge Base:

   Q166862 PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint

1. On the Format menu, point to Column, and click Width. Reduce the listed width by 75%. Click OK.



2. On the Format menu, point to Row, and click Height. Reduce the listed height by 75%, and click OK.



3. On the Format menu, click Cells, and click the Font tab. Under the font size, reduce the listed size by 75%, rounding down. (Although the listed font size will only be reduced to 8 points, you can manually type any number as small as 1. You may see formatting errors if you make the font size smaller than 8 points.)



4. Select the newly formatted section. On the Edit menu, click Copy.



5. Press ALT+TAB to switch back to PowerPoint. On the Edit menu, click Paste.

Workaround 2: Paste the Spreadsheet in Sections

1. Right-click the truncated Excel object and click Open Worksheet Object.



2. Select the portion of the Excel spreadsheet that was originally visible. On the Edit menu, click Copy. If it is a chart, please see the following article in the Microsoft Knowledge Base:

   Q166862 PPT97: Microsoft Excel Chart Cropped When Pasted in PowerPoint

1. Press ALT+TAB to switch back into PowerPoint.



2. On the Edit menu, click Paste.



3. Press ALT+TAB to switch back into Excel. Highlight a section of the Excel spreadsheet that was not displayed in the originally inserted object.
   
   Make sure that the size of your selection does not exceed the first section that you have already copied. On the Edit menu, click Copy.



4. Press ALT+TAB to switch back to PowerPoint. On the Edit menu, click Paste.



5. Using the guides, align the two pasted Excel sections so that they appear to be one seamless spreadsheet. (If the guides are not visible, click Guides on the View menu.)



6. Select both objects by clicking one, and then click the other guide while holding down the SHIFT key.



7. On the Draw menu, click Group.



8. Repeat steps 4 through 8 until the entire spreadsheet is copied.

Additional query words: OFF97 ppt97 ppt 8.0 ppt8 cut cutoff cut-off cropped missing gone covered hidden dropped drawn incorrectly incorrect wrong data chart overlapping under behind editing inplace in-place in place ole activex active-x objects XL97

Keywords : kbinterop kbole kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug