Duplicate Worksheets XLS:1 and XLS:2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have no idea what I did and nobody in my company knows this answer....
someone plesae help!!

I have a worksheet that when I open I get two copies of it for instance
mayquery.xls:1 and mayquery.xls:2

I don't need two copies and I am not sure how to close or get rid of the
second copy.

Does anyone have that answer???

Thanks!
 
you acidently hit <Window><new Window>
just select one of them and click on the red x at the top right of that
window. (not of EXCEl just that window. you will be left with one copy
without the -1 or -2. Save it even if you have made no changes or when you
open it again the two copies will open.
It is a useful tool, but can be annoying when you don't expect it.
 
You have two windows open with the same file.

Someone inadvertantly clicked on Window>New Window.

Select one of the windows and Close to have one Window remaining.

Save that.


Gord Dibben MS Excel MVP
 

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

Shadow/duplicate excel file .xls:2 3
.xls:1 4
Add colour to first duplicate and select 2
TWO FILES OPEN AT SAME TIME XLS:1 AND XLS:2 GROUP??? 4
xls:1 but no xls:2 1
Creating duplicates accidentally 1
Opening multiple XLS files 6
Copy / paste from a table in word .doc to excel .xls worksheet 1

Back
Top