The way it works is that the Save prompt only comes up when you have made changes in the document. This is a standard feature in most windows applications.
Try opening an excel sheet, then enter anything in a cell, and then try to close it. You will be prompted to save.
There is however a 'Save Auto Recover info' option under Tools > Options > Save tab, When checked it will automatically save a temp copy of the file at certain intervals in case of a crash. But this has nothing to do with the regular Save prompt.
Hope this helps.
Not sure what you mean by 'saved if they are not wanted'.
Again unless you have some corruption in program files or the registry, after saving a file, if no subsequent changes are made and you try to exit the program you will not be prompted to save.
This feature cannot be changed.
Okay, follow these steps and tell me what happens?
1- Start Excel from Start > All Programs > Microsoft Excel2- Type 'abc' in cell A13- Click File > Exit
Now4- Click File > Save As , give it a name and a location, then click the Save button.5- Click File > Exit
What happens now?
This is the way it is supposed to work by design.
You see if there are no changes made to the document, there is no reason to ask, or to save it again. It is already saved in that same form. So IT WILL NOT ASK YOU to save it.
But if changes have been made since you last saved it or since you opened the file, IT WILL ASK you if you want to save the file.
That's the way the program works and that cannot be changed.
Does this same problem happen in 1) Word, and 2) Notepad?
Okay in that case try first to use the excel's repair option. Open Excel then click on Help > Detect and Repair.