It will always create an autorecovery file - not quite the same as a backup.
If you don't want to create your own backup when closing the file then maybe
one of the MVP's who visit this site can suggest other settings or provide
you with VBA code that will automatically save a second copy of your file to
a different directory. Afraid that part is over my head.
--
Sincerely, Michael Colvin


" wrote:

Do I need to set up my file to always create backup?
Does this saving feature save only the copy of my backup and not the
original file?

Thanks,

Tom

"Michael" wrote:

Try Tools - Options - Save. This will automatically save a copy of your file
every x minutes to the directory of your choice. HTH
--
Sincerely, Michael Colvin


" wrote:

How do I create a backup file to be stored at different directory? How to
specify the directory that I want the backup file to be stored?

Thanks,
Tom