Why two files opened?

  • Thread starter Thread starter Lisa
  • Start date Start date
L

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
 
Lisa,

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

HTH,
Bernie
MS Excel MVP
 
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.
 
Yeah. it works!!! Thank you so much!

Bernie Deitrick said:
Lisa,

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

HTH,
Bernie
MS Excel MVP
Click to expand...
 
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!
 
Back
Top