When I open a an existing excel worksheet, it duplicates itself a.

[Guest]

When I open an existing excel worksheet, it automatically duplicates itself.
It shows on the bottom of the screen the same worksheet name with a 1 and
then another worksheet with the same name but with a 2. How do I stop that
from happening. Also, when I make changes in the orignal worksheet, the same
changes take place in the second worksheet as well.

 

[Guest]

When I open an existing excel worksheet, it automatically duplicates itself.
It shows on the bottom of the screen the same worksheet name with a 1 and
then another worksheet with the same name but with a 2. How do I stop that
from happening. Also, when I make changes in the orignal worksheet, the same
changes take place in the second worksheet as well.

The above just means an extra window(s) was opened
for the same workbook (via Window > New Window)

Try the steps below to restore things to "normal"

Click Window > Arrange > Tiled > OK
Now click the "x" button in the top right corner of one window to close it
(if more than one window, just "x" until you are left with only one)
Then click the "maximise" button to the left of the "x" to
maximise this last one.
Save the file.


---

 

[David McRitchie]

That would be like workbook: 1, workbook: 2 on the title bar.
The OP indicated his sheet tabs were being duplicated.

Something is causing a sheet to be copied each time you open
the workbook. That would *probably* be an Event Macro see
http://www.mvps.org/dmcritchie/excel/excel.htm#event.htm

See if you have code in the the following:
Right click on the icon to the left of the menu bar, then View Code
is there anything in there. If so try to figure out why it is there.

Also take a look at the following that I'm pretty sure is not what you see
You receive an "An error occurred while loading 'Sheet1111111111111...' "
error message when you open a file in Excel 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;236299

 

[Gord Dibben]

David

My interpretation was that OP was seeing two workbooks open on the Taskbar, not
that the sheet tabs were duplicated.

If two windows open, both will be shown on taskbar as filename.xls:1 and
filename.xls:2

Of course, Windows in Taskbar must be enabled.

Gord

That would be like workbook: 1, workbook: 2 on the title bar.
The OP indicated his sheet tabs were being duplicated.

Something is causing a sheet to be copied each time you open
the workbook. That would *probably* be an Event Macro see
http://www.mvps.org/dmcritchie/excel/excel.htm#event.htm

See if you have code in the the following:
Right click on the icon to the left of the menu bar, then View Code
is there anything in there. If so try to figure out why it is there.

Also take a look at the following that I'm pretty sure is not what you see
You receive an "An error occurred while loading 'Sheet1111111111111...' "
error message when you open a file in Excel 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;236299

Gord Dibben MS Excel MVP

 

[Guest]

... Also, when I make changes in the orignal worksheet, the same
From the above lines, I guessed OP's file had 2 windows opened and
apparently the same sheet (the "original" worksheet) was simultaneously tiled
on-screen. That could explain why the changes he effected on one tile showed
up immediately on the other. Just my take on the post.

---