Microsoft KB Archive/240313

{|
 * width="100%"|

OFF97: Pasting Excel Cells into Another Program May Paste Entire Workbook

 * }

ID: Q240313

-

The information in this article applies to:


 * Microsoft Office 97 for Windows
 * Microsoft Excel for Windows
 * Microsoft Word 97 for Windows
 * Microsoft Outlook 97
 * Microsoft PowerPoint 97 For Windows

-

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 Microsoft Word or Microsoft Outlook, the contents of the entire workbook may be visible, not just the copied cells.

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

CAUSE
This problem can 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 Microsoft 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:
 * 5) Click OK.

The copied cells are pasted into the program. If you double-click the pasted cells, other cells and worksheets in the workbook are not visible.

MORE INFORMATION
When you copy a range of cells in Excel, you can paste the cells into another program by 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. If you want to ensure that only the copied cells are visible when you paste them into another program, it is recommended that you use Paste Special and select one of the formats listed in the "Resolution" section of this article.

Additional query words: OFF97 spreadsheet

Keywords : kbdta word8 word97

Version : WINDOWS:97

Platform :

Issue type : kbprb

Technology :