Auto - backup in excel

[VilMarci]

Dear Community,

I wonder if there's an option in Excel that creates a backup every time of
the file I edit. I need exactly the same that Word does with the "Always
create backup copy" option. No, the autorecovery is not enough.

Thanks,
Marton

 

[Nick Hodge]

Marton

Go to File>Save as.. and select Tools button in dialog and then General
Options... and check always create a back-up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[VilMarci]

Nick,
Thank you.
Marton

Marton

Go to File>Save as.. and select Tools button in dialog and then General
Options... and check always create a back-up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[Opinicus]

Go to File>Save as.. and select Tools button in dialog and then General
Options... and check always create a back-up

That is certainly an odd place to put that option. I never would have found
it on my own. I would have expected it to be under Tools > Options > Save.

Thanks for that tip.

 

[Bob Flanagan]

Marton, a slightly different approach is found at
http://www.add-ins.com/backup_assistant.htm

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel