Home |
Search |
Today's Posts |
#1
|
|||
|
|||
closing 1 file at a time
I have Excel (2003) set up (running in Win2kpro) so that if multiple files
are open then I see each one individually in the task bar. This is what I want. However, unlike Word, when I close one Excel file in the task bar (by right clicking it and choosing the "close" option), ALL the excel files close presumably indicating that I only have 1 instance of Excel running. When I close 1 word doc only that one closes, not all of them. This is very frustrating if I have 3 or 4 files open and they're all currently saved. They all close at once. I don't want that to happen. I only want the one that I close to close. Is this just another annoying inconsistency between office tools or is there a setting that will let me alter this behavior? (the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook - but again, word does not behave this way) Thanks, Keith |
#2
|
|||
|
|||
Have you tried another method of closing individual files, such as clicking
the smaller x button in the upper right corner of the screen? The only circumstance under which Excel should close all open files is when you hold down the Shift key and choose Close from the File menu. "Close" will change to "Close All." "Keith G Hicks" wrote in message ... I have Excel (2003) set up (running in Win2kpro) so that if multiple files are open then I see each one individually in the task bar. This is what I want. However, unlike Word, when I close one Excel file in the task bar (by right clicking it and choosing the "close" option), ALL the excel files close presumably indicating that I only have 1 instance of Excel running. When I close 1 word doc only that one closes, not all of them. This is very frustrating if I have 3 or 4 files open and they're all currently saved. They all close at once. I don't want that to happen. I only want the one that I close to close. Is this just another annoying inconsistency between office tools or is there a setting that will let me alter this behavior? (the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook - but again, word does not behave this way) Thanks, Keith |
#3
|
|||
|
|||
It's an annoying inconsistency.
But if you're careful and close by using the sheet's X (not the application's X), then you should be ok. (Use the lower of the two X's if that makes sense???) Keith G Hicks wrote: I have Excel (2003) set up (running in Win2kpro) so that if multiple files are open then I see each one individually in the task bar. This is what I want. However, unlike Word, when I close one Excel file in the task bar (by right clicking it and choosing the "close" option), ALL the excel files close presumably indicating that I only have 1 instance of Excel running. When I close 1 word doc only that one closes, not all of them. This is very frustrating if I have 3 or 4 files open and they're all currently saved. They all close at once. I don't want that to happen. I only want the one that I close to close. Is this just another annoying inconsistency between office tools or is there a setting that will let me alter this behavior? (the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook - but again, word does not behave this way) Thanks, Keith -- Dave Peterson |
#4
|
|||
|
|||
Thanks for the shift to get "Close All" thing I didn't know about that. But
as far as the smaller 'x' I do know that. I mentioned it below "the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook," I just didn't call it a "smaller x". In Word you can use the larger X or the smaller x and it only closes the current document regardless. I'd just like them to be consistent. I use Word a lot more than I use Excel so it's a habit to use the larger X. "Richard Neville" wrote in message ink.net... Have you tried another method of closing individual files, such as clicking the smaller x button in the upper right corner of the screen? The only circumstance under which Excel should close all open files is when you hold down the Shift key and choose Close from the File menu. "Close" will change to "Close All." "Keith G Hicks" wrote in message ... I have Excel (2003) set up (running in Win2kpro) so that if multiple files are open then I see each one individually in the task bar. This is what I want. However, unlike Word, when I close one Excel file in the task bar (by right clicking it and choosing the "close" option), ALL the excel files close presumably indicating that I only have 1 instance of Excel running. When I close 1 word doc only that one closes, not all of them. This is very frustrating if I have 3 or 4 files open and they're all currently saved. They all close at once. I don't want that to happen. I only want the one that I close to close. Is this just another annoying inconsistency between office tools or is there a setting that will let me alter this behavior? (the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook - but again, word does not behave this way) Thanks, Keith |
#5
|
|||
|
|||
Keith,
When I right-click an Excel workbook on the task bar and click close, it closes only that workbook. This is Excel 2002 with Windows XP. -- Earl Kiosterud www.smokeylake.com "Keith G Hicks" wrote in message ... I have Excel (2003) set up (running in Win2kpro) so that if multiple files are open then I see each one individually in the task bar. This is what I want. However, unlike Word, when I close one Excel file in the task bar (by right clicking it and choosing the "close" option), ALL the excel files close presumably indicating that I only have 1 instance of Excel running. When I close 1 word doc only that one closes, not all of them. This is very frustrating if I have 3 or 4 files open and they're all currently saved. They all close at once. I don't want that to happen. I only want the one that I close to close. Is this just another annoying inconsistency between office tools or is there a setting that will let me alter this behavior? (the same is true when I close from the upper right close button in the Excel window rather than from the upper rigth close button for the current workbook - but again, word does not behave this way) Thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Excel:I set the font color to be "Red". Next time file is open, f. | Excel Discussion (Misc queries) | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |