I auto create a backup for each Word doc. How can I in Excel?
 

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

What version of Excel are you using?

Excel 2007:

Office buttonSaveToolsGeneral OptionsAlways create backupOK

Other versions:

FileSaveToolsGeneral OptionsAlways create backupOK

--
Biff
Microsoft Excel MVP


"Dollins13" wrote in message
...
I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is
this
done in Excel. The Office Assistant wasn't very helpful. Thank you in
advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

For a specific file from.... File Save Dialog window ToolsGeneral Options
check 'Always create backup'

If this post helps click Yes
---------------
Jacob Skaria


"Dollins13" wrote:

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

Thank you. I knew there had to be a way. I just couldn't figure out how. Have
a great week.

"T. Valko" wrote:

What version of Excel are you using?

Excel 2007:

Office buttonSaveToolsGeneral OptionsAlways create backupOK

Other versions:

FileSaveToolsGeneral OptionsAlways create backupOK

--
Biff
Microsoft Excel MVP


"Dollins13" wrote in message
...
I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is
this
done in Excel. The Office Assistant wasn't very helpful. Thank you in
advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

Thank you. I knew there had to be a way. I just couldn't figure out how. Have
a great week.

"Jacob Skaria" wrote:

For a specific file from.... File Save Dialog window ToolsGeneral Options
check 'Always create backup'

If this post helps click Yes
---------------
Jacob Skaria


"Dollins13" wrote:

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

Thank you for responding. I tried that several times, but I can't find the
backup in the directory. Will it be there like it is in Word, or will I have
to look somewhere else? Thanks for the help.

"Jacob Skaria" wrote:

For a specific file from.... File Save Dialog window ToolsGeneral Options
check 'Always create backup'

If this post helps click Yes
---------------
Jacob Skaria


"Dollins13" wrote:

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

Excel backups have the original name and the suffix .xlk (with a displayed
filetype of 'Microsoft Excel Backup File') and will appear in the same folder
as the original. With the Excel backup you can use Autosave and backup
simultaneously

If this post helps click Yes
---------------
Jacob Skaria


"Dollins13" wrote:

Thank you for responding. I tried that several times, but I can't find the
backup in the directory. Will it be there like it is in Word, or will I have
to look somewhere else? Thanks for the help.

"Jacob Skaria" wrote:

For a specific file from.... File Save Dialog window ToolsGeneral Options
check 'Always create backup'

If this post helps click Yes
---------------
Jacob Skaria


"Dollins13" wrote:

I automatically create a backup document in Word. This is very useful when
accidentally saving something I didn't want to change. I would like to do
this in Excel, as I just saved something I didn't want to change. How is this
done in Excel. The Office Assistant wasn't very helpful. Thank you in advance
for any assistance.

I auto create a backup for each Word doc. How can I in Excel?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dollins13" wrote in message
...
Thank you. I knew there had to be a way. I just couldn't figure out how.
Have
a great week.

"T. Valko" wrote:

What version of Excel are you using?

Excel 2007:

Office buttonSaveToolsGeneral OptionsAlways create backupOK

Other versions:

FileSaveToolsGeneral OptionsAlways create backupOK

--
Biff
Microsoft Excel MVP


"Dollins13" wrote in message
...
I automatically create a backup document in Word. This is very useful
when
accidentally saving something I didn't want to change. I would like to
do
this in Excel, as I just saved something I didn't want to change. How
is
this
done in Excel. The Office Assistant wasn't very helpful. Thank you in
advance
for any assistance.