Microsoft KB Archive/196231

= OL2000: Entire Excel Worksheet Copied Rather than Selected Cells =

Article ID: 196231

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Outlook 2000 Standard Edition

-



This article was previously published under Q196231





SYMPTOMS
When you double-click a selection of cells that was pasted from Microsoft Excel into a Microsoft Outlook e-mail message, the entire worksheet is displayed, rather than just the selected cells.



CAUSE
When you use Microsoft Outlook Rich Text as the default e-mail message format, and you paste the cells with the Excel worksheet still open, the default paste option, Microsoft Excel Worksheet, includes the entire worksheet.



RESOLUTION
Choose one of the following options to avoid this behavior:


 * Close the worksheet before pasting into the e-mail message. This causes the cells to be pasted as plain text so that they cannot be opened in Excel.
 * Choose Paste Special with any option other than Microsoft Excel Worksheet.
 * Change the default message format to Plain Text or HTML, or use Microsoft Word to edit e-mail messages.



MORE INFORMATION
To change the default message format:


 * 1) On the Tools menu, click Options.
 * 2) Click the Mail Format tab.
 * 3) Click HTML or Plain Text in the "Send in this message format" list, or click to select "Use Microsoft Word to edit e-mail messages.
 * 4) Click OK to close the Options dialog box.

Additional query words: spreadsheet

Keywords: kbprb KB196231

-

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

© Microsoft Corporation. All rights reserved.