XL12 'Close' button doesn't shutdown XL

  • Thread starter Thread starter GS
  • Start date Start date
G

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.
 
Ron Rosenfeld brought next idea :
If only a single file is open, mine closes.
Click to expand...

Mine requires at least 2 clicks to close any time there are books open
(Including the startup 'Book1')!
 
Gord Dibben has brought this to us :
Why do you bother with opening a startup Book1?


Gord Dibben MS Excel MVP
Click to expand...

Actually, this happens by default! Are you suggesting there's a way to
prevent this? If so, how would I do that?
 
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
 
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
Click to expand...

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?
 
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
 
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.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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 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!
Click to expand...

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
 
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........."?
Click to expand...

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.
 
GS said:
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.
Click to expand...


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.)
 
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
 
Back
Top