How do I enable the Autosave function in Excel 2003?

Question

I've been told autorecover is a seperate function.

Answer 1

Automatic Save or Backup

If you select Tools, do you have an AutoSave?
If not, you need to install an "Add-in" called AutoSave.


1. Select Tools - Add-ins (wait or minimize Excel)

2. Click on the box in front of AutoSave and you should see a checkmark.

3. Click OK.

Now Select Tools to see if you have AutoSave.

4. Click on AutoSave and change the number of minutes.

Note: You do not have to change the minutes, if you are a slow typist.

5. Click on the dot in front of "Save All Open Workbooks" and decide if you want to be prompted each time prior to saving. If you don't want to be bothered every 5 or 10 minutes, make sure this option is not checked.

Open a Backup Copy of a Workbook

To recover the previous saved version of a workbook after a power failure or other problem occurs, you must have previously selected the Always create backup check box in the Save Options dialog box (Save As command, File menu), and you must have saved the workbook more than once.

1. File - Open

2. In the Files of type box, click Backup Files.

3. In the Look in box, select the folder that contains your files.

If you don’t know, click on the cancel button and click on Tools – Options – General. The location should be displayed next to “default file location:” Your files should be stored in c:\data\office2k\Excel2000, but sometimes they are defaulting back to c:\data\office97\Excel. If this is setup incorrectly, you may want to move all of your files to the correct folder and change this path.

Answer 2

Excel 2003 Autosave