Excel exit prompt for auto-save not prompting.

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a user whos machine is not prompting to save a workbook when they close excel, it just closes with no prompts.

He opens up excel types in the some text into a cell clicks close (at this point it SHOULD ask to save the document) and excel just closes without prompting to save it deleting the file and his changes.

I checked options and couldn't find any reason for this. Any and all help would be greatly appreciated.

Thanks!
 
Maybe you have a "helpful" macro.

Try closing excel, then reopen it in safe mode.

Windows start button
run
excel /safe

load your workbook and test it out.

If it's fixed, then the macro could be in that workbook (probably?). Talk to
the developer to see why they did it.

If it happens in all workbooks, then it might be a macro that's loaded when
excel starts. XL loads stuff under tools|addins and in the XLStart folder.

I'd uncheck all the addins and move things out of the xlstart folder.

Then, one-by-one, add each back. See which one causes the trouble.

Oh, and one more spot to look:

Tools|Options|General Tab:
"at startup, open all files in:" <xl2002 wording>
"Alternate Startup File location" <before xl2002 wording>

Clear out that box. (I've never seen anyone really use this.) And some fill it
in by mistake.

Chip Pearson has some additional notes to help diagnose this kind of problem at:
http://www.cpearson.com/excel/StartupErrors.htm
 
Further to Dave's reply ....

It is possible in a macro to disable the alerts as he states.
The code is :-

Application.DisplayAlerts=False


Thr programmer should then set things back to normal by putting this at
the end of the macro :-

Application.DisplayAlerts=True

You can add this yourself, or, if you do not have access to it, make a
one-line macro to do it yourself.
 
Back
Top