You are unable to drag information between workbooks in Excel

When you attempt to drag a selection in a workbook to a different workbook that is minimized on the taskbar, the minimized workbook briefly flashes but does not open, and you are unable to drop the selection onto it.

When you release the mouse button over the minimized workbook, you receive the following message, which is incorrect: You expect the workbook window to open when you drag a selection over it.

This behavior occurs when both of the following conditions are true:

• You drag information from one workbook to a different workbook that is minimized on the Windows taskbar.
  
  -and-
• Both workbooks are open in the same instance of Excel.

To work around this problem, use any of the following methods.

Copy and Paste the Information

To do this, follow these steps:

1. Copy the information from the first workbook.
2. Switch to the second workbook.
3. Paste the information into the second workbook.

Drag Between Open Windows in Excel

To do this, follow these steps:

1. In Excel 2003 and earlier versions, click Arrange on the Window menu. Select a window arrangement, and then click OK.
   
   In Excel 2007, click the View tab, click Arrange All in the Window group.
2. Select an arrangement, and then click OK.
3. Drag the information between the open windows.

Open Each Workbook in a Separate Instance of Excel

To do this, follow these steps:

1. Close one of the workbooks.
2. Minimize Excel.
3. Start another instance of Excel (click Start, point to Programs, and then click Microsoft Excel).
4. In the new instance of Excel, open the workbook that you closed in step 1.

You can now drag information to the other workbook that is minimized on the taskbar.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base: