Closing Excel 2007

  • Thread starter Thread starter John Forrest
  • Start date Start date
J

John Forrest

When I click on the "close" button on Excel, why does Excel close just
the active window instead of exiting from Excel? Now, even if I have
just one workbook open, I have to effectively close Excel twice. Is
there a way to change this behavior?

Thank you,

John
 
I believe you can add a button to the quick custom toolbar. Add a button
that looks like an X (for exit)
 
Good to know, though I'll vent here a bit.

It seems insane to make this change. You have the close window and
close application buttons at the top right, but they both do the same
thing. Why go against the grain of the user's expected results,
especially since none of the other applications work in this manner. It
drives me crazy that I have to close Excel twice.
 
Good to know, though I'll vent here a bit.

It seems insane to make this change. You have the close window and
close application buttons at the top right, but they both do the same
thing. Why go against the grain of the user's expected results,
especially since none of the other applications work in this manner. It
drives me crazy that I have to close Excel twice.







- Show quoted text -
Click to expand...

Hi,

I think this problem is a little more subtle than it appears. Exit
Excel and then open it. With only the blank default workbook open
click the Excel Close X button. You should exit Excel.

Now open Excel and click the New button to open a second blank
workbook. Now click the Excel Close "X" button. One workbook close
but Excel stays open.

I filed a bug report on this back in January 2006 and was told that
this was done for complatibality with other Office Products. For
example, if you open Word 2003 and click the New button so you have
two empty documents open. If you then click the Word close button one
document closes but Word stays open. Admittedly this was not the way
Excel 2003 worked.

I used the approach suggest earlier of adding the Exit command to the
QAT. However, you can still use the old Alt F4 (or Ctrl Alt F4, or
Ctrl Alt Shift F4 or Alt Shift F4).

Cheers,
Shane A. Devenshire
Microsoft Excel MVP
 
Fri, 06 Apr 2007 09:09:40 -0400 from John Forrest
You have the close window and
close application buttons at the top right, but they both do the same
thing. Why go against the grain of the user's expected results,
especially since none of the other applications work in this manner. It
drives me crazy that I have to close Excel twice.
Click to expand...

I'm not at the right computer to check, but I believe Alt-F4 still
works.
 
One workbook close but Excel stays open.

Only with "windows in taskbar" selected, or so it seems.


--
Jim
| > Good to know, though I'll vent here a bit.
| >
| > It seems insane to make this change. You have the close window and
| > close application buttons at the top right, but they both do the same
| > thing. Why go against the grain of the user's expected results,
| > especially since none of the other applications work in this manner. It
| > drives me crazy that I have to close Excel twice.
| >
| >
| >
| > Nick Hodge wrote:
| > > John
| >
| > > Office Button>Exit Excel.
| >
| > > This functionality was changed in XL2007- Hide quoted text -
| >
| > - Show quoted text -
|
| Hi,
|
| I think this problem is a little more subtle than it appears. Exit
| Excel and then open it. With only the blank default workbook open
| click the Excel Close X button. You should exit Excel.
|
| Now open Excel and click the New button to open a second blank
| workbook. Now click the Excel Close "X" button. One workbook close
| but Excel stays open.
|
| I filed a bug report on this back in January 2006 and was told that
| this was done for complatibality with other Office Products. For
| example, if you open Word 2003 and click the New button so you have
| two empty documents open. If you then click the Word close button one
| document closes but Word stays open. Admittedly this was not the way
| Excel 2003 worked.
|
| I used the approach suggest earlier of adding the Exit command to the
| QAT. However, you can still use the old Alt F4 (or Ctrl Alt F4, or
| Ctrl Alt Shift F4 or Alt Shift F4).
|
| Cheers,
| Shane A. Devenshire
| Microsoft Excel MVP
|
 
Before Office 2007 the closing options definitely made more sense to me.

I don't disagree with you but if you want the Excel 2003 behavior all you
have to do is unselect the Windows in Taskbar option (or so I find).

Maybe you meant the Ribbon? The QAT is just a place to put your
customizations, if you want any. You certainly don't have to use it.

--
Jim
<John> wrote in message | Hello--
|
| Before Office 2007 the closing options definitely made more sense to me.
If I wanted to close a workbook, I would click on its close command, and if
I wanted to close all of them, I would click on Excel's close button. If
both buttons do the same thing, what's the point behind having two buttons
at all?
|
| I will get used to using the QAT, I'm just not sure why it's necessary for
me to.
|
| John
|
|
| EggHeadCafe.com - .NET Developer Portal of Choice
| http://www.eggheadcafe.com
 
Good to know, though I'll vent here a bit.

It seems insane to make this change. You have the close window and
close application buttons at the top right, but they both do the same
thing. Why go against the grain of the user's expected results,
especially since none of the other applications work in this manner. It
drives me crazy that I have to close Excel twice.
Click to expand...


I agree - it doesn't seem logical (or intuitive) to make the Excel
Close ("X") button only close the topmost workbook.
That is what the Workbook's Close ("X") button should do.
Just my 2cents, hopefully someone will find a setting to over-ride
that behavior.
 
Just to chime in, I too feel it is just plain wrong & illogical to
have change Excel 2007 to require two clicks to close when only one
sheet is open. To close a single sheet, one should use the "close
window" button instead.

To be fair, I don't mind the degraded exit button except when using it
leaves Excel running with no spreadsheet at all. That's just plain
pointless. That should definitely be fixed back.

To those who claim the two-clicks requirement is the way other Office
apps work, that's just plain wrong. Word and Powerpoint 2007 both
close for me with a single click of the eXit button per document. It
is only Excel that got stupid and won't close when the last document
is being exited.

It is quite apparent that Microsoft has become such a bureaucracy that
it design products "by the numbers" based on market research that asks
the wrong questions. Whoever came up with this change clearly got
"too creative for their own good" and doesn't have much common sense
with things that he/she apparently considers not worth checking
themselves on.
 
To those who claim the two-clicks requirement is the way other Office
apps work, that's just plain wrong. Word and Powerpoint2007bothclosefor me with a single click of the eXit button perdocument. It
Click to expand...

I thought I was going mad! I've just spent ages looking through the
options as I was convinced that I'd turned on some option to leave
Excel open when using the master X button.

What's strange is that I'm sure that on my PC at work, it closes Excel
completely.

Rob.
 
Keith...thanks for the insight. It worked for me after I emptied the XLSTART
folder. I got there by recording a macro and saving it to the Personal.XLSB
file, presumably to make it global. As such, I was stuck with the two-click
close problem. I'll live without the macro. Thanks again.
 
Back
Top