XL12 'Close' button doesn't shutdown XL

[GS]

Why does XL12 not close when clicking the close button. It asks to save
files as expected but doesn't shut down after choosing Yes or No. IOW,
it behaves as though the Cancel button was clicked.

 

[GS]

Ron Rosenfeld brought next idea :

If only a single file is open, mine closes.

Mine requires at least 2 clicks to close any time there are books open
(Including the startup 'Book1')!

 

[Gord Dibben]

Why do you bother with opening a startup Book1?


Gord Dibben MS Excel MVP

 

[GS]

Gord Dibben has brought this to us :

Why do you bother with opening a startup Book1?


Gord Dibben MS Excel MVP

Actually, this happens by default! Are you suggesting there's a way to
prevent this? If so, how would I do that?

 

[Gord Dibben]

Append the /e to your Command line

This is mine for Excel 12.....................

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

You need the double quotes as is. Also note the space before the /e

I will do this through My Computer>Tools>Folder Options>File Types for whichever
particular version of Excel I want as default.

Else, just create shortcuts to your various versions.

You can find more on command line startup switches in Excel Help.


Gord

 

[GS]

Gord Dibben presented the following explanation :

Append the /e to your Command line

This is mine for Excel 12.....................

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e

You need the double quotes as is. Also note the space before the /e

I will do this through My Computer>Tools>Folder Options>File Types for
whichever particular version of Excel I want as default.

Else, just create shortcuts to your various versions.

You can find more on command line startup switches in Excel Help.


Gord

Thanks, Gord! How does this work when opening files from Windows
Explorer? Also, what changed in XL12 that it doesn't shut down until
there's no workbooks open?

 

[Gord Dibben]

When d-click on a file in Windows Explorer, the file will open without a Book1
in whichever version of Excel is default.

i.e. default is Excel 11.........d-click on an *.xlsx file and the file will
open in Excel 11 after converting. Assumes you have the compatibility checker
installed.

I cannot replicate Excel not closing when multiple workbooks are open and none
of them need saving.


Gord

 

[GS]

Gord Dibben expressed precisely :

When d-click on a file in Windows Explorer, the file will open without a
Book1
in whichever version of Excel is default.

Yes, Gord, this is normal behavior.

i.e. default is Excel 11.........d-click on an *.xlsx file and the file
will
open in Excel 11 after converting. Assumes you have the compatibility
checker
installed.

Yes, I do have the compatibility checker installed. This also works as
you suggest.

I cannot replicate Excel not closing when multiple workbooks are open and
none
of them need saving.

Strange, but I've never been able to close XL2007 unless there were no
workbooks open. Maybe somethings buggy with my copy of MSO12 because it
happens on my test machines as well!

Thanks for the effort! -Much appreciated...

 

[Gord Dibben]

Gord Dibben expressed precisely :

Yes, Gord, this is normal behavior.


Yes, I do have the compatibility checker installed. This also works as
you suggest.


Strange, but I've never been able to close XL2007 unless there were no
workbooks open. Maybe somethings buggy with my copy of MSO12 because it
happens on my test machines as well!

Does your XL2007 appear to close but is left in memory or does it remains in
view?

Any messages other than "Do you want to save........."?


Gord

 

[GS]

Gord Dibben has brought this to us :

Does your XL2007 appear to close but is left in memory or does it remains in
view?

Any messages other than "Do you want to save........."?

The UI remains in view with no workbooks open.

I only get the "Do you want to save..." msg if the active workbook has
formulas (no changes made). Otherwise, this behavior is as expected but
after the last workbook closes the UI still remains until I click the
'X' again.

 

[Clif McIrvin]

Gord Dibben has brought this to us :

The UI remains in view with no workbooks open.

I only get the "Do you want to save..." msg if the active workbook has
formulas (no changes made). Otherwise, this behavior is as expected
but after the last workbook closes the UI still remains until I click
the 'X' again.

Not fully investigated, but it appears that xl2010 does the same thing
.... ie; if there is a modified workbook open when I click the 'X' Excel
does not exit after I dismiss the "Do you want to save..." dialog. (I
don't normally try to exit Excel with open worlbooks; but that did
happen to me this morning.)

 

[Gord Dibben]

Tested with three open workbooks.

One with no changes made and two with changes made.

Closed Application and got the "do you want to save" for the altered workbooks.

Click "Yes to all" and Excel saves the workbooks and closes.

Click No twice and Excel closes.

I cannot get Excel to stay open when it has been asked to close.

Have no idea what makes my setup different.


Gord

 

[Clif McIrvin]

Thanks for taking the time to try and re-produce the behavior. Much
appreciated.

Clif