ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2 mirror files with :1 and :2 - why? (https://www.excelbanter.com/excel-discussion-misc-queries/18556-2-mirror-files-1-2-why.html)

DJR

2 mirror files with :1 and :2 - why?
 
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
appreciated!

JulieD

Hi

you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem

Cheers
JulieD


"DJR" wrote in message
...
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I
open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of
mirroring,
or changes being tracked, but track changes is turned off. Any help is
appreciated!




DJR

Julie,
Thats not it, closing one file closes the other. The 2 files are tied at
the hip somehow and whatever happens to one happens to the other. Very
strange!


"JulieD" wrote:

Hi

you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem

Cheers
JulieD


"DJR" wrote in message
...
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I
open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of
mirroring,
or changes being tracked, but track changes is turned off. Any help is
appreciated!





Dave Peterson

JulieD wants you to close one of the windows--not the workbook.

Click on the window you don't want anymore (book1.xls:2 (:2??)), then hit ctrl-w
to close that window.

Don't forget to save the workbook the way you like it.

Debra Dalgleish has nice pictures at:
http://www.contextures.com/xlfaqApp.html#TwoWindows

If you want to (carefully) hit one of those X's to close the window.

DJR wrote:

Julie,
Thats not it, closing one file closes the other. The 2 files are tied at
the hip somehow and whatever happens to one happens to the other. Very
strange!

"JulieD" wrote:

Hi

you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem

Cheers
JulieD


"DJR" wrote in message
...
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I
open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of
mirroring,
or changes being tracked, but track changes is turned off. Any help is
appreciated!





--

Dave Peterson


All times are GMT +1. The time now is 11:43 PM.

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