| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No prompt to save Excel file which has changed
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No prompt to save Excel file which has changed
Make sure Autosave is not saving for you.
-- Gary''s Student - gsnu200728 "Neil" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No prompt to save Excel file which has changed
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. "Gary''s Student" wrote: Make sure Autosave is not saving for you. -- Gary''s Student - gsnu200728 "Neil" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No prompt to save Excel file which has changed
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) -- Gary''s Student - gsnu200728 "Neil" wrote: 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. "Gary''s Student" wrote: Make sure Autosave is not saving for you. -- Gary''s Student - gsnu200728 "Neil" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No prompt to save Excel file which has changed
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. Neil wrote: 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? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have excel prompt for a file name and save location | Excel Discussion (Misc queries) | |||
| Excel claims exclusive file may have been changed on save | Excel Discussion (Misc queries) | |||
| Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
| how to disable save prompt on closing excel file in automated mode | Excel Discussion (Misc queries) | |||
| Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
Linear Mode
