Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

I clicked on something and now my original (one) workbook has opened as two
workbooks with the above listed extensions. If I do something in one, it
will appear in the other. If I close out and re- open the workbook from it's
original state, they still appear. I clicked too fast or hit something and
now I can't get it back to original form. Can you help?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as two
workbooks with the above listed extensions. If I do something in one, it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something and
now I can't get it back to original form. Can you help?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

I tried that but it wouldn't let me close one window without the other. I'll
try it again though. Thanks!

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as two
workbooks with the above listed extensions. If I do something in one, it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something and
now I can't get it back to original form. Can you help?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as two
workbooks with the above listed extensions. If I do something in one, it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something and
now I can't get it back to original form. Can you help?




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as
two
workbooks with the above listed extensions. If I do something in one,
it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something
and
now I can't get it back to original form. Can you help?








  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

When I first closed the window, it closed both books and when I reopened it,
it appeared as two windows again. THEN :-), I right clicked on the bottom
taskbar on one of the books and closed it that way, then I still had one
workbook open and saved that. ALL IS WELL! Thank you! I don't ever really
use two books, side by side like this so that's whyy it threw me! Thank you
again for your help! :-)

"AndyB" wrote:

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as
two
workbooks with the above listed extensions. If I do something in one,
it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something
and
now I can't get it back to original form. Can you help?






  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

Thanks for the feedback - and I'm glad you're sorted!!

Andy.

"Mar" wrote in message
...
When I first closed the window, it closed both books and when I reopened
it,
it appeared as two windows again. THEN :-), I right clicked on the bottom
taskbar on one of the books and closed it that way, then I still had one
workbook open and saved that. ALL IS WELL! Thank you! I don't ever
really
use two books, side by side like this so that's whyy it threw me! Thank
you
again for your help! :-)

"AndyB" wrote:

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one
of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened
as
two
workbooks with the above listed extensions. If I do something in
one,
it
will appear in the other. If I close out and re- open the workbook
from
it's
original state, they still appear. I clicked too fast or hit
something
and
now I can't get it back to original form. Can you help?








  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

If it happens again, you may find this easier.

Select the window you don't want.
hit ctrl-w (to close it)
save your workbook in that state.

Mar wrote:

When I first closed the window, it closed both books and when I reopened it,
it appeared as two windows again. THEN :-), I right clicked on the bottom
taskbar on one of the books and closed it that way, then I still had one
workbook open and saved that. ALL IS WELL! Thank you! I don't ever really
use two books, side by side like this so that's whyy it threw me! Thank you
again for your help! :-)

"AndyB" wrote:

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as
two
workbooks with the above listed extensions. If I do something in one,
it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something
and
now I can't get it back to original form. Can you help?







--

Dave Peterson
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

OK, New problem That was not quite it! I have an excel workbook that when I
opened it and accidentially clicked on something by Window, my file now shows
as one file but with two workbooks in it and the extension after each is
checkbook.xls1, and then .xls2. I CAN'T seem to close one without the other.
We tried the New Window and that created a new workbook and we were able to
close that new window but we still can't close the workbook and have only one
sheet to work on. If I make any changes to the one labelled .xls1, it makes
the same changes in .xls2. Sorry, but this is so frustrating.

"AndyB" wrote:

Thanks for the feedback - and I'm glad you're sorted!!

Andy.

"Mar" wrote in message
...
When I first closed the window, it closed both books and when I reopened
it,
it appeared as two windows again. THEN :-), I right clicked on the bottom
taskbar on one of the books and closed it that way, then I still had one
workbook open and saved that. ALL IS WELL! Thank you! I don't ever
really
use two books, side by side like this so that's whyy it threw me! Thank
you
again for your help! :-)

"AndyB" wrote:

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one
of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened
as
two
workbooks with the above listed extensions. If I do something in
one,
it
will appear in the other. If I close out and re- open the workbook
from
it's
original state, they still appear. I clicked too fast or hit
something
and
now I can't get it back to original form. Can you help?









  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mar
 
Posts: n/a
Default two workbooks with extension .xls1 and .xls2

OK, I am going to the source after work to work on this. Will let you know!
Thanks for your help!

"Dave Peterson" wrote:

If it happens again, you may find this easier.

Select the window you don't want.
hit ctrl-w (to close it)
save your workbook in that state.

Mar wrote:

When I first closed the window, it closed both books and when I reopened it,
it appeared as two windows again. THEN :-), I right clicked on the bottom
taskbar on one of the books and closed it that way, then I still had one
workbook open and saved that. ALL IS WELL! Thank you! I don't ever really
use two books, side by side like this so that's whyy it threw me! Thank you
again for your help! :-)

"AndyB" wrote:

Yes - Window/New Window - as I put in my my email!

Andy.

"Mar" wrote in message
...
any other ideas! What did I click on to create this, do you know?

"AndyB" wrote:

Hi

You've opened a New Window (from the Window dropdown). Just close one of
your windows and save your workbook.

Andy.

"Mar" wrote in message
...
I clicked on something and now my original (one) workbook has opened as
two
workbooks with the above listed extensions. If I do something in one,
it
will appear in the other. If I close out and re- open the workbook from
it's
original state, they still appear. I clicked too fast or hit something
and
now I can't get it back to original form. Can you help?







--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
.xls:1 Katie Excel Discussion (Misc queries) 4 November 22nd 05 08:40 PM
Excel Duplicating Workbooks luke1438 Excel Discussion (Misc queries) 1 August 11th 05 07:50 PM
Shadow/duplicate excel file .xls:2 Courtney Excel Discussion (Misc queries) 3 June 22nd 05 11:18 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"