XL: Workbook Appears in Multiple Windows When Opened (272025)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q272025 SYMPTOMS
When you open a workbook, Microsoft Excel may display multiple windows that contain a copy of that same workbook. Additionally, the title bar displays the workbook name followed by a colon and a number, such as Book1:1 and Book1:2. The taskbar in Microsoft Windows also displays a button for each of these windows.
CAUSE
This behavior occurs if the workbook was saved when multiple windows were open for that workbook.
RESOLUTION
To change this behavior, close the extra windows, and then save the workbook. To do this, follow these steps:
- Click the Close button (the X in the upper-right corner) of the window that you do not want.
NOTE: If you click Close on the File menu, Excel closes all windows that contain the workbook. Because the settings are retained, you will see all the windows again the next time you open the workbook. - Repeat step 1 until only the window that you want is open.
NOTE: When only one window is still open, the title bar no longer displays a colon and a number. - On the File menu, click Save to save the workbook.
REFERENCESFor more information about how to use multiple windows, click Microsoft Excel Help on the
Help menu, type multiple windows in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
Modification Type: | Major | Last Reviewed: | 11/24/2003 |
---|
Keywords: | kbprb KB272025 |
---|
|