Why two files opened?

[Lisa]

I use Office 2003. There is an Excel file. When I open it, it opens two
identical Excel files. If I change one, the other one get changed as well.
Why this happen? Need help!

Thanks in advance!

Lisa

 

[Bernie Deitrick]

Lisa,

You have a second window open. Close one of the windows, then re-save the
file.

HTH,
Bernie
MS Excel MVP

 

[Dave Peterson]

Saved from a previous post:

Do you see:

book1.xls:1
and
book2.xls:2

If you do then this isn't really two copies of the workbook. It's just two
views (or windows) into the same workbook.

You can select the window you don't want to see, then hit ctrl-w to close that
window.

Then save the workbook or you'll be doing it again!

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(in xl2003 menus)
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.

 

[Lisa]

Yeah. it works!!! Thank you so much!

Lisa,

You have a second window open. Close one of the windows, then re-save the
file.

HTH,
Bernie
MS Excel MVP

 

[Lisa]

Hi Dave, thank you for your reply. Yes, I see book1.xls and book.xls. After I
closed one and click save. It open with one file now. Thanks again!