Is there an auto save in Office 2007 Excel

J

Jean

Is there a setting somewhere for a spreadsheet to automatically save every 10
minutes, as there was an option in previous versions of Excel?
 
R

Roger Govier

Hi
Round Office button>Excel Options>Save>Save Auto-recover Information every x
minutes
 
G

Gord Dibben

Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals. Good or bad feature depending on how
you look at it.

Versions since 2000 use Auto Recovery which only creates a timed but temporary
backup file which is deleted when the workbook is closed normally.

Auto Recovery is a safety valve in the event of an Excel crash while a workbook
is open.

Jan Karel Pieterse has an addin called AutoSafe
which doen't alert before saving.

http://www.jkp-ads.com/download.asp

(look for AutoSafe.zip)

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or
puts them in the recycle bin). And the user can always restore the backups
from the recycle bin.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top