Duplicate File

  • Thread starter Thread starter Kurt
  • Start date Start date
K

Kurt

When using Excel 2000, and opening a file, a second file
with the same name plus :2 opens and changes with changes
made in the first file. The file disappears once I close
the first file. Why is this happening and how do I stop
it?
 
Kurt,

I think that you ma have used the window>New Window cammand from within
Excel.
This command allows you to open another view into the same workbook.
As it is the smae workbook in each instance, changes to any view will
update the other.
The new window is denoted by the :2 on the end of the window caption.
Subsequent views are :3, :4 etc.

You can get rid of them by simply closing the second window.
 
When you close the window you don't want, you can click on that window's X in
the top right corner--not the application's X.

Or click in the window you don't want and hit ctrl-F4.

And don't forget to save it with all those windows closed--else you'll have to
do it again.

(This can be very useful when you want to see two parts of the workbook at the
same time.)
 
Thanks for your help regarding the new window in Excel.
But why is this new window opening automatically? There
must be an option or setting to make it do that.
 
Excel remembers the last way the file was last saved. If it had multiple
windows then, it'll have multiple windows when you open it up.

And an unlikely reason: Your workbook could have a macro that opens multiple
windows. (But I doubt this is the case--it's much more likely that someone did
a Window|new window by mistake and saved it that way.)
 
Back
Top