OL2000: Entire Excel Worksheet Copied Rather than Selected Cells (196231)


The information in this article applies to:

  • Microsoft Outlook 2000
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.
Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kbprb KB196231
©2003 Microsoft Corporation. All rights reserved.