You cannot paste any attributes into a workbook in another instance of Excel (917637)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 97 for Windows
SYMPTOMSConsider the following scenario. You run two instances of Microsoft Excel. You open a workbook in each instance of Excel. Then, you use the Paste Special menu command to paste attributes from a cell in one workbook to a cell in the other workbook. In this scenario, you cannot paste any attributes into the other workbook. The Paste Special dialog box from Excel does not appear. Instead, the Paste Special dialog box from Microsoft Windows appears. Therefore, you cannot select any one of the following options: - Formulas
- Values
- Formats
- Comments
These options appear only in the Paste Special dialog box from Excel. CAUSEThis behavior occurs because Excel cannot use its internal copying functionality when you run multiple instances of Microsoft Excel. Instead, Excel relies on the Paste Special dialog box from Windows for its copying functionality. When you run a single instance of Excel, Excel uses its internal copying functionality. Therefore, the Paste Special dialog box from Excel is available. WORKAROUNDTo work around this behavior, open both workbooks in the same instance of Excel.
| Modification Type: | Minor | Last Reviewed: | 4/25/2006 |
|---|
| Keywords: | kbClipboard kbtshoot kbExpertiseBeginner kbprb KB917637 kbAudEndUser |
|---|
|