Microsoft KB Archive/827109

= Some cells of an Excel 2003 workbook do not appear pasted into a presentation in PowerPoint 2003 =

Article ID: 827109

Article Last Modified on 8/29/2006

-

APPLIES TO


 * Microsoft Office PowerPoint 2003

-





SYMPTOMS
When you paste a large range of cells from a Microsoft Excel worksheet into a Microsoft Office PowerPoint 2003 presentation, only a part of the cells that are copied from the workbook may be visible. This problem occurs when you use the Paste Special command or the Excel Table smart tag option to paste the cells as a Microsoft Office Excel 2003 worksheet object.



CAUSE
This behavior occurs because the size of the Excel worksheet exceeds the default frame size for the pasted object. The size of the Excel worksheet varies according to the number of the rows, the height of the rows, the number of the columns, the width of the columns, and the size of the font.



WORKAROUND
To display all the rows and all the columns of the Excel worksheet in the PowerPoint presentation, use one of the following workarounds. These workarounds do not always correct the behavior. The success of the workaround depends on the size of the information that you are trying to paste into the PowerPoint presentation.

Method 1: Reduce the font size, the column widths, and the row heights
In Excel, reduce the font size, the column widths, and the row heights to the minimum size that is acceptable. This reduction reduces the size of the worksheet.

Method 2: Use the Paste command instead of the Paste Special command
On the Edit menu, click Paste instead of Paste Special, and then use the default format when you paste.

Method 3: Increase the size of the slides in the presentation
Increase the size of the PowerPoint presentation slides. To do so, follow these steps.

Note You cannot change the size or the orientation of individual slides in a presentation. Any changes that you make in Page Setup affect the whole presentation.
 * 1) In PowerPoint, click Page Setup on the File menu.
 * 2) Use the UP ARROW key to change the width and the height of the slide.
 * 3) Click OK.

Method 4: Paste the cells in sections
If you still cannot paste the whole range of cells that you want, paste the range of cells in multiple sections. To do so, follow these steps:
 * 1) In Excel, select a range of cells that is sufficiently small to copy into PowerPoint.
 * 2) On the Edit menu, click Copy.
 * 3) In PowerPoint, click Paste on the Edit menu.
 * 4) In Excel, select the remainder of the range of cells.
 * 5) On the Edit menu, click Copy.
 * 6) In PowerPoint, click Paste on the Edit menu. Note You can align the sections in the PowerPoint slide so that they appear contiguous.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section of this article.

Additional query words: PPT cut off crop cropped missing truncated gone small excel xl spreadsheet range

Keywords: kbprb kbdisplay KB827109

-

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

© Microsoft Corporation. All rights reserved.