Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Opening a Workbook with Two Windows

Summary: If you open a workbook and you notice that it shows two windows for the data, you may wonder how to get rid of one of those windows. Follow the steps in this tip, and you won't be bothered by those extra windows any more. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you open a workbook that has been worked on by someone else, you may be surprised when you see not one, but two windows open. If these windows are named (in the title bar) something like MyFile.xls:1 and MyFile.xls:2, then the two windows represent different views of the same worksheet.

To solve this problem, make a change or two somewhere in the worksheet. (Make the change in either window; it doesn't matter.) This change can be as simple as editing a cell or entering something into a blank cell and then deleting it.

Next, close one of the windows by clicking the Close button in the upper-right corner of the window. The window should close, but the other window remain open. Notice, as well, that the :1 or :2 notation should disappear from the remaining window's title bar.

Now save the file and close it. When you later reopen it, the extra window is gone. It was there before because Excel remembers how many windows you have open for any given file. It saves that information with the workbook file itself, and then opens that many windows when the workbook is later opened.

If this doesn't solve the problem, it could be that the workbook being opened has an AutoOpen macro that is running, and that the macro is opening the additional window. Changing macro-based behavior like this entails changing the macro or disabling it in some way.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2224) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.
 
Check out Top Fifteen Tips for Financing Christmas today!