Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
+ in filename | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Getting only the filename with no extension | Excel Worksheet Functions | |||
Building a Filename | Excel Worksheet Functions |