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?
Peo Sjoblom - 14 May 2008 22:50 GMT
Just close the window with the duplicate and then save the workbook

Signature
Regards,
Peo Sjoblom
>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?
JE McGimpsey - 14 May 2008 22:51 GMT
New Window creates a new *window* into the sheet, not a new sheet.
Just close one window (e.g., click on the close button).
> 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?
FSt1 - 14 May 2008 22:55 GMT
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
> 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?
louise - 14 May 2008 23:08 GMT
When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!
> hi,
> technically you don't delete, you just close the window.
[quoted text clipped - 7 lines]
> > arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
> > delete these?
JE McGimpsey - 14 May 2008 23:25 GMT
Click the X in the *document* window, not the *application window*.
> When I click the "X" it closes excel. I now have 25 windows of the same
> spreadsheet workbook. HELP!
FSt1 - 14 May 2008 23:30 GMT
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
> When I click the "X" it closes excel. I now have 25 windows of the same
> spreadsheet workbook. HELP!
[quoted text clipped - 10 lines]
> > > arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
> > > delete these?
louise - 14 May 2008 23:58 GMT
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.
> hi
> should have read more carefully. if you are comparing 2 seperated file then
[quoted text clipped - 19 lines]
> > > > arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
> > > > delete these?
FSt1 - 15 May 2008 01:00 GMT
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
> 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
[quoted text clipped - 24 lines]
> > > > > arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
> > > > > delete these?
Dave Peterson - 14 May 2008 22:59 GMT
Select the window to close
hit ctrl-w
Save the workbook the way you like.
> 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?

Signature
Dave Peterson