PS: I forgot to mention that the behavior also takes place with no addins
loaded and starting Excel in Safe Mode.

"Alan Cannon" wrote in message news:...
Thanks, Nick. This behavior started when I upgraded from Office 2000 to
Office 2003. The Personal.xls and other sheets are the same ones used
previously. I have tried a new workbook opened alone in Excel, then using
the close workbook and close application X's as well as the Close and
Exit
commands in the File menu. They all act the same. This is a real puzzle.

"Nick Hodge" wrote in message
...
Mole Chaser

This is not standard behaviour. You should check you have no code in
your
personal.xls for example or any add-ins loading that are marking any
workbooks as 'clean' and therefore not displaying a prompt to save.

Bear in mind to however that using the 'X' at the top of the application
operates totally differently to Word for example which closes the
document.
XL closes the application and any workbooks within. It should show a
prompt
however, but if multiple workbooks are open it only asks once if you
answer
'No'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mole Chaser" <Mole wrote in message
...
The rest of the Office 2003 suite does prompt to save a new or changed
file,
but Excel does not. This has cost me lots of re-work when I get in a
hurry
or
have multiple windows open and inadvertently click to close the wrong
window
or app.

It happens 100% of the time, for a new file or a modified file.

Alan

I wonder if code has switched alerts off

Press Alt+F11 in Excel and the VBE should launch. Hopefully a window here is
called 'immediate window'. If not go to the view menu and activate. In here
type

Application.DisplayAlerts = True

and press enter. Now close the VBE and Excel. Does that fix it?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Alan Cannon" wrote in message
...
PS: I forgot to mention that the behavior also takes place with no addins
loaded and starting Excel in Safe Mode.

"Alan Cannon" wrote in message news:...
Thanks, Nick. This behavior started when I upgraded from Office 2000 to
Office 2003. The Personal.xls and other sheets are the same ones used
previously. I have tried a new workbook opened alone in Excel, then using
the close workbook and close application X's as well as the Close and
Exit
commands in the File menu. They all act the same. This is a real puzzle.

"Nick Hodge" wrote in message
...
Mole Chaser

This is not standard behaviour. You should check you have no code in
your
personal.xls for example or any add-ins loading that are marking any
workbooks as 'clean' and therefore not displaying a prompt to save.

Bear in mind to however that using the 'X' at the top of the
application
operates totally differently to Word for example which closes the
document.
XL closes the application and any workbooks within. It should show a
prompt
however, but if multiple workbooks are open it only asks once if you
answer
'No'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mole Chaser" <Mole wrote in message
...
The rest of the Office 2003 suite does prompt to save a new or
changed
file,
but Excel does not. This has cost me lots of re-work when I get in a
hurry
or
have multiple windows open and inadvertently click to close the wrong
window
or app.

It happens 100% of the time, for a new file or a modified file.