Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DJR
 
Posts: n/a
Default 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!
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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!



  #3   Report Post  
DJR
 
Posts: n/a
Default

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!




  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"