Changing autosave setting in Excel 1

[kevd]

The autosave setting in Excel defaults to:

Automatically save every 10 minutes
Save Active workbook only
Prompt before saving

Is there any way of changing this setting so that it is valid for every workbook that Excel works with, i.e. doesn't prompt user whether they want to autosave (surely that defeats the object of autosaving?), and saves all open workbooks?

Thanks

Kevin

 

[Dreamboat]

Kevin: don't know about the all workbooks thing, but want to caution you about Excel's autosave.

Excel's autosave, unlike Word's, saves the Excel file to the SAME NAME. If you decide after a few minutes that you've totally hosed your file, well, too late to save it to a new name.

Autosave is an option for each user. It is not an option saved with a file. If you turn it on for your PC, it will always be on for your PC.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[EricRN]

Kevin,

If you're using Excel 97, Microsoft makes this statement:

"You can modify AutoSave settings, including how often to save, which workbooks to save, and whether to be prompted before saving. To do this, on the Tools menu, click AutoSave, and select the options you want in the AutoSave dialog box."

Hope this helps.

Eric