Auto - backup in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VilMarci - 06 Apr 2007 10:45 GMT

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

Reply to this Message

Nick Hodge - 06 Apr 2007 10:51 GMT

Marton

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
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

> Dear Community,
>
[quoted text clipped - 4 lines]
> Thanks,
> Marton

Reply to this Message

VilMarci - 06 Apr 2007 13:21 GMT

Nick,
Thank you.
Marton

> Marton
>
[quoted text clipped - 9 lines]
>> Thanks,
>> Marton

Reply to this Message

Opinicus - 06 Apr 2007 16:15 GMT

> 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.

Signature

Bob
http://www.kanyak.com

Reply to this Message

Bob Flanagan - 06 Apr 2007 16:21 GMT

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

> Dear Community,
>
[quoted text clipped - 4 lines]
> Thanks,
> Marton

Reply to this Message