No prompt to save Excel file which has changed

[Guest]

I am used to the pop up in Excel which prompts you to save a file which has
been changed. All of a sudden that prompt is gone. How do I reinstate it?

 

[Guest]

Make sure Autosave is not saving for you.

 

[Guest]

I hate Autosave and have it turned off. I think the problem is isolated to
files on a network, as opposed to my hard drive.

 

[Guest]

If you don't mind a little VBA, this macro will save before closing:


Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save
End Sub

to install it go to the menu bar (File, Edit, View...)right-click the tiny
Excel icon just to the left of File. Select View code and paste the macro
into the open VBA window. Then just close the VBA window.

Once installed in a workbook, you can edit away. If you do a
File > Exit
or
File > Quit

The save will be automatic (no prompt at all)

 

[Dave Peterson]

Go into the VBE and check to see what addins are loaded when you start excel.

I _think_ that I've read posts that describe this problem. But heck if I
remember the addin that caused it.

If it turns out that it is an addin, please post back with the name -- so google
will have it.