Excel doesn't prompt me to save when closing a file / excel?

When I close out of excel, excel doesn't prompt me if I want to save or not (when I did not save my changes prior to closing). Why is this happening and how can I fix this?
dm25Asked:
Who is Participating?
 
Rory ArchibaldCommented:
Is this with all workbooks or one particular one? Do you have any add-ins loaded, and if so, which ones?
Regards,
Rory
0
 
psychakias2Commented:
This can be due to the following reasons:

1) The file has already been saved automatically.

If you have Office 2002 or greater, you will find this setting here: Tools > Options > Save > Save autorecover every XX minutes
If you have Office 2000 or less, you will find this setting here: Tools > Autosave

2)The file has hides VB code that saves it automatically.

To look if there is such code, Press ALT-F11 and look, and when the VBA window pops up, double click on the workgroup name (on the left side of your screen) to see the code that is behind this workbook.

You would be looking for something like this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Me.Save
End Sub
0
 
AdamRobinsonCommented:
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
dm25Author Commented:
phychakias,

The > Options > Save > Save autorecover every XX minutes option is for autorecovery, not for autosafe.....I don't think its the same thing. I tried setting the autorecovery to 1 minute, and after 1 minute I close excel and open it back up again and it doesn't automatically save the file.

As for the VB code, shouldn't it still apply even if it is hidden?
0
 
Rory ArchibaldCommented:
You might have code that does something like:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
me.saved = true
End Sub
in which case Excel wouldn't bother saving the file.

Regards,
Rory
0
 
dm25Author Commented:
Rorya,

I have excel version 2002. The add ins that I have loaded are 1) Analysis Toolpack 2) Eurocurrency tools 3) Lookup wizard 4) Conditional sum wizard 5) Solver.
0
 
Rory ArchibaldCommented:
And is it just one workbook you have this problem with or all of them? (or somewhere in between)
Do you have any code in the workbook(s) in question?
Regards,
Rory
0
 
psychakias2Commented:
dm25, if you find the code that I mentioned in my first post, then all you have to do is to hit delete. :-)
0
 
dm25Author Commented:
Not sure which solution is right (I didn't have to resolve this problem), so I thought I would give everyone points.  Thank you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.