Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Duplicate Workbooks Opening.

Duplicate Workbooks Opening

by Allen Wyatt
(last updated December 12, 2014)

6

Joan has a problem with one of her Excel workbooks: When she opens it, Excel always "replicates" the workbook. Once opened, Joan reports that she has two workbooks showing in the task bar. Both contain the proper workbook name, but one is followed by a 1 and the other followed by a 2.

Believe it or not, this problem is actually a feature of Excel. What you are seeing is two windows, both open on the same workbook. Excel allows you to create multiple windows on the same workbook by using the Window | New Window. Each new window has the same name, except they have a suffix consisting of a colon and a number that indicates the window number (1, 2, 3, etc.).

When you save a workbook that has multiple windows, the next time you open the workbook it will display the same number of windows. If you want to get rid of some of the windows, you need to close them. You do this by clicking the Close Window control. (This is the X at the upper-right corner of the worksheet, not at the upper-right of the program window. It is black, not red, although it should be just below the red X. If you hover the mouse pointer over it, you'll see the ToolTip "Close Window" appear.)

Once you close any windows you don't want, save the workbook again. The next time you open it, you should see only a single window.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2994) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Duplicate Workbooks Opening.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Disabling Dragging and Dropping

Excel allows you to easily paste information into a worksheet, including through simply dragging and dropping the ...

Discover More

Pop-up Windows in Word

Want to add a small pop-up window over a word in your document? There is no way to do this directly in Word, but you can use ...

Discover More

Too Many Cell Formats

The error message "too many cell formats" can be difficult to fix. This tip describes ways you can attempt to get rid of the ...

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

MORE EXCELTIPS (MENU)

Invalid Names when Opening Workbook

Don't you hate opening a workbook and seeing error messages? If you see a message that some "invalid names" were detected in ...

Discover More

Turning Off Sharing

All good things must come to an end at some point. When you are done sharing your workbook with others, this is how you can ...

Discover More

Opening Two Workbooks with the Same Name

If you have two workbooks that each have the same name, opening them at the same time in Excel could cause some problems. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven minus 6?

2017-02-28 19:33:55

Deborah Bergfeld

I am trying to find the solution for the same problem but in the Mac version of Excel 2011. There is no x in the upper right corner and using the suggestion below doesn't make one appear.


2016-10-26 02:34:09

shaps

Thank you Nasha


2016-02-24 23:56:07

Nasha

For the 2013, there is no x button when the window is maximized. you have to use View->Arrange All->Cascade and then click on the X button for the window that is extra!

Thanks a lot, it was so annoying and I could not figure out how to do it.


2015-09-16 10:16:59

Dot

Thank you. Hope this works.


2015-03-11 13:43:51

Peter K

You're a life saver! I've been tormented by that problem for year and for some reason never thought to hit the X button. Thank you so much!


2013-08-30 14:42:56

Michelle Ayala

Thank you!! I couldn't for the life of me figure this out. :)


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share