Why when opening a spreadsheet, do two copies appear to open?

P

Pete W

When opening a spreadsheet, it appears to open two separate copies of the
worksheet. Why is this, and how do I stop it?
 
D

Dave Peterson

Do you see:

book1.xls:1
and
book2.xls:2

If you do then this isn't really two copies of the workbook. It's just two
views (or windows) into the same workbook.

You can select the one you don't want to see, then hit ctrl-w to close that
window.

Then save the workbook or you'll be doing it again!

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.
 
G

Gord Dibben

Someone hit Window>New Window and you have two views of the same workbook.

Close one of the windows then save.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 08:04:02 -0700, Pete W <Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to delete name:1 xxxx:2 2
Opening Excel produces multiple copies 2
edited spreadsheet saves as template 9
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
How do I make an Excel file not open 2 copies? 2
Two copies of document open 4
Excel opening 2 identical & parallel copies of a file. Won't stop 2
Unwanted Excel Spreadsheet Attached 2

Top