Excel 2002 - Why does 1 workbook open as 2 versions

[Guest]

I have a user who has a Workbook (which is shared, and pages are linked to
each other). She opened it up this morning, and it opened as 2 "versions".
The naming convention was Workbook.xls:1 and Workbook.xls:2. If she made a
change to one, it was "duplicated" on the second "version". She advised all
she did to the worksheet was to unfreeze the pane. She worked on the
worksheet yesterday, and it did not do this. When she opened it this
morning, the view was at 100% (from 75%), and Workbook "versions" were
showing (and the directory where the workbook is saved only shows 1 workbook,
not 2). As far as I am aware, we do not have the add-in to "compare"
worksheets. The other person with access to this workbook advised that he
did not edit the workbook and did not have it open. Can anyone advise what
this may be? Any advice would be much appreciated.

 

[Gord Dibben]

What you are seeing is one worbook with two duplicate Windows.

Close one of the Windows using the "x" in that window.

Now save the workbook.

Someone inadvertently created two windows using Window>New Window.


Gord Dibben Excel MVP

 

[Guest]

Thank you!!! This Worked!!!!