You are currently offline, waiting for your internet to reconnect

When you open a workbook, Excel may display multiple windows that contain a copy of that same workbook

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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:
  1. 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.
  2. 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.
  3. Press CTRL+S to save the workbook.
MORE INFORMATION
Excel allows you to open multiple windows to view a single workbook. This is useful when you want to view different sheets in the same workbook or different areas of a large worksheet simultaneously. For example, to view multiple sheets in the active workbook, follow these steps:
  1. Press CTRL+N to create a new winodw.

    Excel designates multiple windows of the same workbook by appending a colon and a number to the file name on the title bar.
  2. Switch to the new window, and then click a sheet that you want to view.
  3. Repeat steps 1 and 2 for each sheet that you want to view in a window.
If you close and save the file when you are viewing multiple windows, the window settings are retained. Therefore, when you reopen the workbook, you see the same multiple windows.
multiple same screens files versions askmaxwell XL2002 XL2001 XL2000 XL98 XL2003 XL2007
Properties

Article ID: 272025 - Last Review: 01/02/2007 21:48:43 - Revision: 3.1

  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
  • kbexpertisebeginner kbprb KB272025
Feedback
> crosoft.com/ms.js" '="">ft.com/ms.js" '="">