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

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

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

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

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

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.

For additional information how to manage multiple workbook windows, click the article numbers below to view the articles in the Microsoft Knowledge Base: For more information about linked and embedded objects in Microsoft Word, click Microsoft Word Help on the Help menu, type insert information in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.