ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filename.xls:1 and filename.xls:2 (https://www.excelbanter.com/excel-discussion-misc-queries/167535-filename-xls-1-filename-xls-2-a.html)

Christina C.

filename.xls:1 and filename.xls:2
 
What would cause the following to happen?

When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2

Trying to make that stop and just have one file.

Thanks,
Christina

Conan Kelly

filename.xls:1 and filename.xls:2
 
Christina,

You have 2 windows open for the same file: WindowNew Window

I'm guessing that when you click the Window menu, sometimes New Window gets
clicked automatically.

If 2 windows for the same file open automatically when you open the file,
maybe it is because it is a MS XL Workspace (*.xlw) and it was saved that
way.

HTH,

Conan

"Christina C." wrote in message
...
What would cause the following to happen?

When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2

Trying to make that stop and just have one file.

Thanks,
Christina




Dave Peterson

filename.xls:1 and filename.xls:2
 
In xl2003, you can create a new window via:
Window|New Window

Then the windows can be arranged so that you can see both (Window|Arrange).

It can be very useful when you have to see a different worksheet--or even a
different portion of the same worksheet.

If you don't want these multiple "views", you can select the window to close,
then hit ctrl-f4.

Remember to save the workbook the way you like.

"Christina C." wrote:

What would cause the following to happen?

When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2

Trying to make that stop and just have one file.

Thanks,
Christina


--

Dave Peterson

Gord Dibben

filename.xls:1 and filename.xls:2
 
Someone inadvertently went to WindowNew Window

Click on the "x" to close one of these windows then save the remaining one.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 13:48:44 -0800 (PST), "Christina C."
wrote:

What would cause the following to happen?

When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2

Trying to make that stop and just have one file.

Thanks,
Christina



Pete_UK

filename.xls:1 and filename.xls:2
 
You just have two windows open on the same file. Use the close window
icon (X) in the top right corner of the file window (NOT the Excel
window) to close one of them, and then save the file so that it
doesn't happen next time you open it.

Hope this helps.

Pete

On Nov 27, 9:48 pm, "Christina C." wrote:
What would cause the following to happen?

When you click on Window -- you see a listing for the name of the
spreadsheet.xls:1 and then name of the spreadsheet.xls:2

Trying to make that stop and just have one file.

Thanks,
Christina



Christina C.

filename.xls:1 and filename.xls:2
 
Conan,

Thanks for getting back to me. I am drawing a blank as to why this
does this (trying to support one of my users).

1. I did not create the file.

2. I double-checked; it is not an *.xlw file. But the two windows do
open automatically.

My user got sent the file in email by someone.

Any ideas?

Thanks,
Christina

Christina C.

filename.xls:1 and filename.xls:2
 
Thank you very much everyone... wow; got alot of responses.

Lack of sleep will do that to ya. I just didn't know HOW it got that
way in the first place. Yes, probably the individual sending the file
inadvertantly clicked on Window, New Window.

Thanks again....
Christina

Conan Kelly

filename.xls:1 and filename.xls:2
 
Christina,

As I learned from the other posts, it does not need to be an *.xlw file in
order for both windows to open when the file is opened.

If the file is saved with 2 windows open, it will open both windows when the
file is opened.

Close one of the windows and then save the file. That should correct the
problem.

HTH,

Conan
"Christina C." wrote in message
...
Conan,

Thanks for getting back to me. I am drawing a blank as to why this
does this (trying to support one of my users).

1. I did not create the file.

2. I double-checked; it is not an *.xlw file. But the two windows do
open automatically.

My user got sent the file in email by someone.

Any ideas?

Thanks,
Christina





All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com