PC Review


Reply
Thread Tools Rate Thread

canceling new window

 
 
BK
Guest
Posts: n/a
 
      2nd Oct 2007
Using Win XP and Excel 2003

I have a workbook with 3 worksheets. At one point I opened a new window and
arranged them vertically so that I could do some data comparisons between
sheet 1 and sheet 2. When I was done, I did not close the extra window; I
simply maximized the original window. Then I saved the workbook and closed
it.

Now, whenever I open the workbook, I get two identical files that open.
Each one has the same 3 worksheets. The two windows are the same filename
with different extensions. One has the extension .xls:1 and the other has
the extension .xls:2

When I close both and go to my folder to delete one of them, the only thing
that is listed is the .xls so there is nothing to delete.

How do I get rid of the second "window" that opens so that I am back to just
one?


 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      2nd Oct 2007
It isn't two separate files - just two windows on the same file. To
delete one of them, select the window with :2 at the end and press the
close icon (X) for the file window (not the Excel window), then save
the file - when you open it again you will only have one window
visible.

Hope this helps.

Pete

On Oct 2, 10:38 am, "BK" <nos...@nospam.com> wrote:
> Using Win XP and Excel 2003
>
> I have a workbook with 3 worksheets. At one point I opened a new window and
> arranged them vertically so that I could do some data comparisons between
> sheet 1 and sheet 2. When I was done, I did not close the extra window; I
> simply maximized the original window. Then I saved the workbook and closed
> it.
>
> Now, whenever I open the workbook, I get two identical files that open.
> Each one has the same 3 worksheets. The two windows are the same filename
> with different extensions. One has the extension .xls:1 and the other has
> the extension .xls:2
>
> When I close both and go to my folder to delete one of them, the only thing
> that is listed is the .xls so there is nothing to delete.
>
> How do I get rid of the second "window" that opens so that I am back to just
> one?



 
Reply With Quote
 
BK
Guest
Posts: n/a
 
      2nd Oct 2007
Thanks so much.



"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It isn't two separate files - just two windows on the same file. To
> delete one of them, select the window with :2 at the end and press the
> close icon (X) for the file window (not the Excel window), then save
> the file - when you open it again you will only have one window
> visible.
>
> Hope this helps.
>
> Pete
>
> On Oct 2, 10:38 am, "BK" <nos...@nospam.com> wrote:
>> Using Win XP and Excel 2003
>>
>> I have a workbook with 3 worksheets. At one point I opened a new window
>> and
>> arranged them vertically so that I could do some data comparisons between
>> sheet 1 and sheet 2. When I was done, I did not close the extra window;
>> I
>> simply maximized the original window. Then I saved the workbook and
>> closed
>> it.
>>
>> Now, whenever I open the workbook, I get two identical files that open.
>> Each one has the same 3 worksheets. The two windows are the same
>> filename
>> with different extensions. One has the extension .xls:1 and the other
>> has
>> the extension .xls:2
>>
>> When I close both and go to my folder to delete one of them, the only
>> thing
>> that is listed is the .xls so there is nothing to delete.
>>
>> How do I get rid of the second "window" that opens so that I am back to
>> just
>> one?

>
>



 
Reply With Quote
 
Pete_UK
Guest
Posts: n/a
 
      2nd Oct 2007
You're welcome - thanks for feeding back.

Pete

On Oct 2, 12:53 pm, "BK" <nos...@nospam.com> wrote:
> Thanks so much.
>
> "Pete_UK" <pashu...@auditel.net> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > It isn't two separate files - just two windows on the same file. To
> > delete one of them, select the window with :2 at the end and press the
> > close icon (X) for the file window (not the Excel window), then save
> > the file - when you open it again you will only have one window
> > visible.

>
> > Hope this helps.

>
> > Pete

>
> > On Oct 2, 10:38 am, "BK" <nos...@nospam.com> wrote:
> >> Using Win XP and Excel 2003

>
> >> I have a workbook with 3 worksheets. At one point I opened a new window
> >> and
> >> arranged them vertically so that I could do some data comparisons between
> >> sheet 1 and sheet 2. When I was done, I did not close the extra window;
> >> I
> >> simply maximized the original window. Then I saved the workbook and
> >> closed
> >> it.

>
> >> Now, whenever I open the workbook, I get two identical files that open.
> >> Each one has the same 3 worksheets. The two windows are the same
> >> filename
> >> with different extensions. One has the extension .xls:1 and the other
> >> has
> >> the extension .xls:2

>
> >> When I close both and go to my folder to delete one of them, the only
> >> thing
> >> that is listed is the .xls so there is nothing to delete.

>
> >> How do I get rid of the second "window" that opens so that I am back to
> >> just
> >> one?- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Canceling Sky macca400 General Discussion 2 21st Oct 2009 07:54 PM
moving/copying/canceling window goes on and on Kate Windows Vista General Discussion 1 24th Jun 2008 09:09 PM
canceling adp changes =?Utf-8?B?c21hcnR5?= Microsoft Access ADP SQL Server 1 21st Jun 2006 12:02 AM
Canceling Window Creation Gary Brown Microsoft Dot NET 1 20th Oct 2005 03:05 AM
Canceling sent email FeFe Microsoft Outlook 1 15th Jun 2004 06:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:48 AM.