Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel closes more than one worksheet
I'm running XP and the latest Office software. You know how if you have
multiple Word docs open, you see multiple bars down on the task bar? And if you close one of them with the red X box at the top right (the one for the application, not the smaller window one), only that one particular Word file closes; all the rest stay open? Why doesn't Excel do that? Whenever I use the big red X to close out of something, it wants to close all Excel worksheets at once. Why is it different only for Excel? I'm so used to it being the other way in other applications that I've lost data this way on Excel. Is there a way to change this? |
#2
|
|||
|
|||
Tools--Options, View tab. Check Windows in Taskbar.
************ Anne Troy www.OfficeArticles.com "Ed" wrote in message ... I'm running XP and the latest Office software. You know how if you have multiple Word docs open, you see multiple bars down on the task bar? And if you close one of them with the red X box at the top right (the one for the application, not the smaller window one), only that one particular Word file closes; all the rest stay open? Why doesn't Excel do that? Whenever I use the big red X to close out of something, it wants to close all Excel worksheets at once. Why is it different only for Excel? I'm so used to it being the other way in other applications that I've lost data this way on Excel. Is there a way to change this? |
#3
|
|||
|
|||
Nope.
Excel and MSWord do behave differently. I think the best thing to do is to train yourself not to use that X on the application window. But if your workbook is dirty (has been changed without subsequent save), then you will be prompted to save (or cancel). So at least it tries to help you not lose changes! I personally don't like the windows in taskbar that you're using--I like the old xl97 view. And then it really does look like I want to close the application when I click the application window X. (I use ctrl-tab to swap between workbooks and then I don't have to go through the window menu, too.) Ed wrote: I'm running XP and the latest Office software. You know how if you have multiple Word docs open, you see multiple bars down on the task bar? And if you close one of them with the red X box at the top right (the one for the application, not the smaller window one), only that one particular Word file closes; all the rest stay open? Why doesn't Excel do that? Whenever I use the big red X to close out of something, it wants to close all Excel worksheets at once. Why is it different only for Excel? I'm so used to it being the other way in other applications that I've lost data this way on Excel. Is there a way to change this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i create a path to a worksheet from outside of excel | Excel Discussion (Misc queries) | |||
Excel worksheet linking | Excel Worksheet Functions | |||
Rename Excel Worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |