Excel file Autosave on close

[Demi]

Hello,

I'm having office 2003, I simultaneously works with multiple excel files and many times i gets confuse at the closing files all together and some times they gets save or sometimes they don't. Please tell me how can i force excel to autosave files on close. it shouldn't prompt me always. Is it possible?

[Techguru01]

What you wanna do exactly? On every close excel prompt you to save it or not. But if it won't ask you to save and auto save then it will save all unrequired changes also, i don't think its good idea to make excel o auto save files.

[Jackson2]

Enable and adjust AutoRecover and AutoSave

1. Click the Microsoft Office Button Button image, and then click Excel Options.
2. Click Save.
3. Select the Save AutoRecover information every x minutes check box.
4. In the minutes list, specify how often you want the program to save your data and the program state.
   
   

   The amount of new information that the recovered file contains depends on how frequently a Microsoft Office program saves the recovery file. For example, if the recovery file is saved only every 15 minutes, your recovered file won't contain your last 14 minutes of work before the power failure or other problem occurred.

5. Optionally, you can change the location (specified in the AutoRecover file location box) where the program automatically saves a version of files you work on.

Source: Microsoft.com

[Navman]

To activate the AutoSave feature, follow these steps:

• In the Tools menu, click Add-Ins.
• In the Add-Ins dialog, select the AutoSave Add-in check box, then click OK.
  

[Tillie]

To do this, when you're on your Excel file, go to Tools> Macros> Visual Basic Editor (until the 2003 version of Excel).

• Opens a new window named "Microsoft Visual Basic".
  
• Double click "ThisWorkbook" on the left in the game theory called "Project - VBA Project".
  
• In the new window that opens, type this:
  
  

  Private Sub Workbook_BeforeClose(Cancel As Boolean)
  Application.DisplayAlerts = False
  ActiveWorkbook.Save
  End Sub

  • "ThisWorkbook" means "Excel Sheet".
  • "BeforeClose" means "Before the closing".
  
  
• This code corresponds to a function which will then apply to your workbook (that is to say all of your sheets), at its closure.
  
• The first line of the function "Application.DisplayAlerts=False" can not display warnings such as "Do you want to save changes to ...".
  
• The second line of the function "ActiveWorkbook.SaveAs" save your workbook. Then the function ends.
  
• Close the window "Microsoft Visual Basic.
  
• Modify your document. Close Excel.
  
• It should not ask you if you want to save. Reopen your document: Changes have been saved.