If you mean make a backup whenever you save..........

FileSave AsToolsGeneral Options. "Always create a Backup"

When you save the workbook a filename.xlk file is created.

This backup file will always be one version behind the current saved one.

If you mean incremental backups while you work, see Norman's post.

Excel 2002 and 2003 have the "Autorecovery" feature which does not make
incremental saves while you work.

You can use the AUTOSAVE.XLA from an earlier version of Excel if you can get
your hands on one.


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 06:45:05 -0800, "balindy"
wrote:

How do I make a back up file in excel?