Excel file opens with a colon followed by a number in the Excel Title Bar

I

ITAnnaJones

When I open a particular file in Excel 2002 or 2003, the file name
appears as filename:2 when it is opened in Excel. Is this something
that needs to be corrected? What does the :2 mean after the file name?
In Windows Explorer, the :2 does not appear in the filename. Any
assistance is appreciated. Thanks.
 
D

David Biddulph

It sounds like your file has two windows open. Look at the Windows menu and
see whether that shows two windows on the file? If you want to close one
window, click on the smaller x just below the large red X at the top
right-hand corner.
 
I

ITAnnaJones

Two windows open when the file opens. One is listed as :1 and the other
as :2

How can this be corrected?

Thanks.
 
G

Gord Dibben

Read David's reply below for how-to.

After closing the one window, restore the other window then Save.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

I just activate the window I don't want and hit ctrl-w.

Then remember to save--like Gord recommended.
 
Top