Save Default in Excel

[Rich19]

Where do I change the default value for the time interval in Microsoft Office for saving. I worked on a file last night and Excel did not save the work. I was told that Windows saves every 10 minutes, mine never saves. I am running Windows XP Professional and Office 97. Thanks
Rich

 

[carrr]

Tools > Add-ins > Autosave add-in needs to be selected and added. If not there, you'll need to get your disk and add the add-ins to the installation.
Once installed, autosave will show up on your tools menu (4th from the top on my pc running Office 97) and you can tweak the time settings there.

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[carrr]

You might also want to look at the AutoBackup add-in:

http://www.rb-ad.dircon.co.uk/rob/excelvba/utils/index.htm

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[vahiatek]

Hi

Tools -> options -> save tab and beside the autosave check box chqnge the 10 mn into the time interval you want.

Good luck.

 

[carrr]

There is no save tab under files > options in Excel 97.
Word has this funcitonality, Excel requires an add-in. There is no "global" save functionality in Office 97, only at the program level.

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[Rich19]

Thanks for providing the right path. This worked by going to Add Ins under Tools. I get a popup box now every 10 minutes the autosave feature. PROBLEM SOLVED!

 

[carrr]

You can uncheck the prompt function if you want it to automatically do it, without giving you the popup.

"'Tis an ill wind that blows no minds." - Malaclypse the Younger