ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why two files opened? (https://www.excelbanter.com/excel-discussion-misc-queries/243985-why-two-files-opened.html)

Lisa

Why two files opened?
 
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

Why two files opened?
 
Lisa,

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

HTH,
Bernie
MS Excel MVP


"Lisa" wrote in message
...
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



Dave Peterson

Why two files opened?
 
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 wrote:

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


--

Dave Peterson

Lisa

Why two files opened?
 
Yeah. it works!!! Thank you so much!

"Bernie Deitrick" wrote:

Lisa,

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

HTH,
Bernie
MS Excel MVP


"Lisa" wrote in message
...
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

Why two files opened?
 
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!

"Dave Peterson" wrote:

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 wrote:

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


--

Dave Peterson



All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com