Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Without explanation I have 2 different files that whenever I open them in
Excel, 2 workbooks open, both with the same name. I can switch between the 2, and changes to the one are refleceted in the other. I can't figure out how to get back to just a single instance of the workbook. -- Thanks MUCH! Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Hi Dave,
This is the result of Window | New. To remove the extraneous window, click the X close button at the top right of the document window - not the Excel window! --- Regards, Norman "Dave the wave" wrote in message ... Without explanation I have 2 different files that whenever I open them in Excel, 2 workbooks open, both with the same name. I can switch between the 2, and changes to the one are refleceted in the other. I can't figure out how to get back to just a single instance of the workbook. -- Thanks MUCH! Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Close one. Save the file. Re-open. Should be fixed.
This can generally be re-created by openeing any file, choosing Windows New Window, and then saving it. -- Hmm...they have the Internet on COMPUTERS now! "Dave the wave" wrote: Without explanation I have 2 different files that whenever I open them in Excel, 2 workbooks open, both with the same name. I can switch between the 2, and changes to the one are refleceted in the other. I can't figure out how to get back to just a single instance of the workbook. -- Thanks MUCH! Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Select the window that you don't want.
hit ctrl-w save the workbook or you'll have to do it again next time. Dave the wave wrote: Without explanation I have 2 different files that whenever I open them in Excel, 2 workbooks open, both with the same name. I can switch between the 2, and changes to the one are refleceted in the other. I can't figure out how to get back to just a single instance of the workbook. -- Thanks MUCH! Dave -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
"Norman Jones" wrote in
: Hi Dave, This is the result of Window | New. To remove the extraneous window, click the X close button at the top right of the document window - not the Excel window! --- Regards, Norman "Dave the wave" wrote in message ... Without explanation I have 2 different files that whenever I open them in Excel, 2 workbooks open, both with the same name. I can switch between the 2, and changes to the one are refleceted in the other. I can't figure out how to get back to just a single instance of the workbook. -- Thanks MUCH! Dave Clicking the "close" button for one of the workbooks did the trick. Thanks much for your help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
Hi Dave,
Clicking the "close" button for one of the workbooks did the trick. Good - but note Dave Peterson's advice about saving the file! --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does worksheet exist | Excel Discussion (Misc queries) | |||
File opens, worksheet does not display | Excel Discussion (Misc queries) | |||
Clicking an Exel file in my documents opens a blank worksheet | Excel Discussion (Misc queries) | |||
Can you auto-trigger a sound file to play when a worksheet opens? | Excel Worksheet Functions | |||
Does a worksheet exist? | Excel Programming |