How do I get rid of duplicate spreadsheets?

L

louise

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?
 
P

Peo Sjoblom

Just close the window with the duplicate and then save the workbook


--


Regards,


Peo Sjoblom
 
J

JE McGimpsey

New Window creates a new *window* into the sheet, not a new sheet.

Just close one window (e.g., click on the close button).
 
F

FSt1

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1
 
L

louise

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!
 
F

FSt1

hi
should have read more carefully. if you are comparing 2 seperated file then
you don't create a new window, you just arrange-tiled. do you have 2 files
open? or are you trying to tile 2 sheets in the same file. if so you may be
creating new sheets. are all the sheets the same? same data?

regards
FSt1
 
L

louise

Sometimes when I choose arrange-tile nothing happens. These are 2 separate
workbooks. The data is the same in all the windows of the one workbook that
is duplicated. I tried to delete sheet but since all the pages in the
workbook are linked, the links disappear.
 
F

FSt1

hi
i'm getting more confused my the post. we are in troubleshoot mode.
what happen when you close the file? close xl? do all of the sheet return?
what is excel calling all the new sheets?

regards
FSt1
 
Top