Microsoft KB Archive/282155

= XL2002: Unable to Insert Workbook If Open in More Than One Window =

Article ID: 282155

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Word 2002 Standard Edition

-



This article was previously published under Q282155





SYMPTOMS
When you attempt to insert a Microsoft Excel workbook into Microsoft Word, you receive the following error message:

The object was created in Excel.

This application is not available to open this object.

Make sure that the application is properly installed and that it has not been deleted, moved or renamed.



CAUSE
This behavior occurs if you saved your Microsoft Excel workbook when it was open in more than one window.



WORKAROUND
To work around this issue, save your Excel workbook while it is open in only one window, and then insert the workbook again.



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



MORE INFORMATION
Microsoft Excel allows you to have the same workbook open in more than one window so that you can work on multiple sheets at the same time (on the Window menu, click New Window). You can also use this feature to view different areas of the same sheet simultaneously.

When you work with multiple windows that contain a copy of the same workbook, the title bar of each window displays the name of the workbook followed by a colon and a sequential number. For example, the first window of Book1.xls workbook is called Book1:1, the second one is called Book1:2, and so on. Each of these windows also has its own button on the taskbar.

You can close individual workbook windows by selecting the window and pressing CTRL+W.

If you want to view two worksheets simultaneously, follow these steps:
 * 1) Open a workbook in Microsoft Excel.
 * 2) On the Window menu, click New Window.
 * 3) On the Window menu, click Arrange, and then click OK.

