OFF2000: Pasting Excel Cells into Another Program may Paste Entire Workbook

• Microsoft Office 2000
• Microsoft Excel 2000
• Microsoft Word 2000
• Microsoft Outlook 2000
• Microsoft PowerPoint 2000

SYMPTOMS

If you double-click a range of cells that have been copied from an Excel workbook and then pasted into another program, such as Word or Outlook, the contents of the entire workbook may be visible, not just the copied cells.

This may cause a problem if the workbook contains information that you do not want others to see.

CAUSE

This problem will occur when you paste the copied cells as a Microsoft Excel Worksheet Object.

RESOLUTION

To prevent this problem from occurring, make sure that you paste the copied cells in a format other than Microsoftb Excel Worksheet or Microsoft Excel Worksheet Object. One method of doing this is to use the Paste Special command, as in the following example:

1. In Excel, copy the range of cells that you want to appear in another program.



2. Switch to the other program and place the insertion point where you want the copied cells to be pasted.



3. On the Edit menu, click Paste Special.



4. In the list of formats, select one of the following:




      Unformatted Text            Bitmap
      Unformatted Unicode Text    Picture
      Formatted Text (RTF)        Picture (Bitmap)
      HTML                        Picture (Metafile)
      Text                        Picture (Enhanced Metafile) 

NOTE: Don't select either Microsoft Excel Worksheet or Microsoft Excel Worksheet Object.


5. Click OK.

MORE INFORMATION

When you copy a range of cells in Excel, you can paste the cells into another program using several different formats, including text, HTML, and pictures.

You also have the option of pasting the cells as a Microsoft Excel Worksheet Object. The worksheet object contains all of the data from the workbook, not just the cells you copied. As a result, you can view all of the cells in the workbook.

If you click Paste on the Edit menu in another program, the copied cells may be pasted as a Microsoft Excel Worksheet Object. For this reason, it is recommended that you use Paste Special and select one of the formats listed earlier if you want to ensure that only the copied cells are visible when you paste them into another program.

Additional query words: OFF2000 XL2000 WD2000 OL2000 PP2000

Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: June 10, 1999