Turning always save backup file to off

Ken · External Since: Sep 05, 2004 Posts: 347

I used to know how to set this off using the template function. It has not
happened in some time, but reappeared when my work PC got updated from Excel
97 to 2003.
Can anyone out there shed a little light?
Thanks.

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

To stop creating the .wbk files?

File|SaveAs|Tool|General Options|Uncheck "always create backup"

This setting is for for that one workbook/template. It's not an application or
user setting.

Ken wrote:
>
> I used to know how to set this off using the template function. It has not
> happened in some time, but reappeared when my work PC got updated from Excel
> 97 to 2003.
> Can anyone out there shed a little light?
> Thanks.

--

Dave Peterson

Ken · External Since: Sep 05, 2004 Posts: 347

Looks good, Dave. Many thanks!

"Dave Peterson" wrote:

> To stop creating the .wbk files?
>
> File|SaveAs|Tool|General Options|Uncheck "always create backup"
>
> This setting is for for that one workbook/template. It's not an application or
> user setting.
>
> Ken wrote:
> >
> > I used to know how to set this off using the template function. It has not
> > happened in some time, but reappeared when my work PC got updated from Excel
> > 97 to 2003.
> > Can anyone out there shed a little light?
> > Thanks.
>
> --
>
> Dave Peterson
>

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Did you mean .XLK files?

..WBK are Word backup files

But I see by Ken's response he's happy.

Gord

On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod DeleteThis @verizonXSPAM.net>
wrote:

>To stop creating the .wbk files?
>
>File|SaveAs|Tool|General Options|Uncheck "always create backup"
>
>This setting is for for that one workbook/template. It's not an application or
>user setting.
>
>Ken wrote:
>>
>> I used to know how to set this off using the template function. It has not
>> happened in some time, but reappeared when my work PC got updated from Excel
>> 97 to 2003.
>> Can anyone out there shed a little light?
>> Thanks.

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

Oops.

Thanks for the correction (again???--I think you've corrected me on this
before--but I haven't learned!).

Gord Dibben wrote:
>
> Did you mean .XLK files?
>
> .WBK are Word backup files
>
> But I see by Ken's response he's happy.
>
> Gord
>
> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod DeleteThis @verizonXSPAM.net>
> wrote:
>
> >To stop creating the .wbk files?
> >
> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
> >
> >This setting is for for that one workbook/template. It's not an application or
> >user setting.
> >
> >Ken wrote:
> >>
> >> I used to know how to set this off using the template function. It has not
> >> happened in some time, but reappeared when my work PC got updated from Excel
> >> 97 to 2003.
> >> Can anyone out there shed a little light?
> >> Thanks.

--

Dave Peterson

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

What's really strange and frightening is.............I remember the difference
between the two<g>

On Mon, 14 May 2007 18:58:22 -0500, Dave Peterson <petersod RemoveThis @verizonXSPAM.net>
wrote:

>Oops.
>
>Thanks for the correction (again???--I think you've corrected me on this
>before--but I haven't learned!).
>
>Gord Dibben wrote:
>>
>> Did you mean .XLK files?
>>
>> .WBK are Word backup files
>>
>> But I see by Ken's response he's happy.
>>
>> Gord
>>
>> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod RemoveThis @verizonXSPAM.net>
>> wrote:
>>
>> >To stop creating the .wbk files?
>> >
>> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
>> >
>> >This setting is for for that one workbook/template. It's not an application or
>> >user setting.
>> >
>> >Ken wrote:
>> >>
>> >> I used to know how to set this off using the template function. It has not
>> >> happened in some time, but reappeared when my work PC got updated from Excel
>> >> 97 to 2003.
>> >> Can anyone out there shed a little light?
>> >> Thanks.

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

So do I--at least for today, er, this morning.

Gord Dibben wrote:
>
> What's really strange and frightening is.............I remember the difference
> between the two<g>
>
> On Mon, 14 May 2007 18:58:22 -0500, Dave Peterson <petersod.RemoveThis@verizonXSPAM.net>
> wrote:
>
> >Oops.
> >
> >Thanks for the correction (again???--I think you've corrected me on this
> >before--but I haven't learned!).
> >
> >Gord Dibben wrote:
> >>
> >> Did you mean .XLK files?
> >>
> >> .WBK are Word backup files
> >>
> >> But I see by Ken's response he's happy.
> >>
> >> Gord
> >>
> >> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod.RemoveThis@verizonXSPAM.net>
> >> wrote:
> >>
> >> >To stop creating the .wbk files?
> >> >
> >> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
> >> >
> >> >This setting is for for that one workbook/template. It's not an application or
> >> >user setting.
> >> >
> >> >Ken wrote:
> >> >>
> >> >> I used to know how to set this off using the template function. It has not
> >> >> happened in some time, but reappeared when my work PC got updated from Excel
> >> >> 97 to 2003.
> >> >> Can anyone out there shed a little light?
> >> >> Thanks.

--

Dave Peterson

David Kaplan · External Since: Aug 05, 2009 Posts: 1

"Dave Peterson" wrote:

> So do I--at least for today, er, this morning.
>
> Gord Dibben wrote:
> >
> > What's really strange and frightening is.............I remember the difference
> > between the two<g>
> >
> > On Mon, 14 May 2007 18:58:22 -0500, Dave Peterson <petersod.TakeThisOut@verizonXSPAM.net>
> > wrote:
> >
> > >Oops.
> > >
> > >Thanks for the correction (again???--I think you've corrected me on this
> > >before--but I haven't learned!).
> > >
> > >Gord Dibben wrote:
> > >>
> > >> Did you mean .XLK files?
> > >>
> > >> .WBK are Word backup files
> > >>
> > >> But I see by Ken's response he's happy.
> > >>
> > >> Gord
> > >>
> > >> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod.TakeThisOut@verizonXSPAM.net>
> > >> wrote:
> > >>
> > >> >To stop creating the .wbk files?
> > >> >
> > >> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
> > >> >
> > >> >This setting is for for that one workbook/template. It's not an application or
> > >> >user setting.
> > >> >
> > >> >Ken wrote:
> > >> >>
> > >> >> I used to know how to set this off using the template function. It has not
> > >> >> happened in some time, but reappeared when my work PC got updated from Excel
> > >> >> 97 to 2003.
> > >> >> Can anyone out there shed a little light?
> > >> >> Thanks.
>
> --
>
> Dave Peterson
>

David Kaplan · External Since: Aug 05, 2009 Posts: 1

I want to turn ON the Excel automatic backup facility in Excel 2003, the one
that makes *.xlk files. I know to do it on a file by file basis using
File/save as/... But isn't there a way to set an option to make backups for
ALL excel files, the way there is for WORD?

"Dave Peterson" wrote:

> So do I--at least for today, er, this morning.
>
> Gord Dibben wrote:
> >
> > What's really strange and frightening is.............I remember the difference
> > between the two<g>
> >
> > On Mon, 14 May 2007 18:58:22 -0500, Dave Peterson <petersod.DeleteThis@verizonXSPAM.net>
> > wrote:
> >
> > >Oops.
> > >
> > >Thanks for the correction (again???--I think you've corrected me on this
> > >before--but I haven't learned!).
> > >
> > >Gord Dibben wrote:
> > >>
> > >> Did you mean .XLK files?
> > >>
> > >> .WBK are Word backup files
> > >>
> > >> But I see by Ken's response he's happy.
> > >>
> > >> Gord
> > >>
> > >> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod.DeleteThis@verizonXSPAM.net>
> > >> wrote:
> > >>
> > >> >To stop creating the .wbk files?
> > >> >
> > >> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
> > >> >
> > >> >This setting is for for that one workbook/template. It's not an application or
> > >> >user setting.
> > >> >
> > >> >Ken wrote:
> > >> >>
> > >> >> I used to know how to set this off using the template function. It has not
> > >> >> happened in some time, but reappeared when my work PC got updated from Excel
> > >> >> 97 to 2003.
> > >> >> Can anyone out there shed a little light?
> > >> >> Thanks.
>
> --
>
> Dave Peterson
>

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

Nothing built into excel.

You could create a workbook template named book.xlt and store it in your XLStart
folder. Make sure you include all the settings you like in that template.

In xl2003, a new workbook will be created based on this workbook when you click
on the New Icon on the standard toolbar.

For existing workbooks, you could create a macro that you could run that would
save the file the way you like.

But it'll be up to you to run it each time you want.

David Kaplan wrote:
>
> I want to turn ON the Excel automatic backup facility in Excel 2003, the one
> that makes *.xlk files. I know to do it on a file by file basis using
> File/save as/... But isn't there a way to set an option to make backups for
> ALL excel files, the way there is for WORD?
>
> "Dave Peterson" wrote:
>
> > So do I--at least for today, er, this morning.
> >
> > Gord Dibben wrote:
> > >
> > > What's really strange and frightening is.............I remember the difference
> > > between the two<g>
> > >
> > > On Mon, 14 May 2007 18:58:22 -0500, Dave Peterson <petersod.TakeThisOut@verizonXSPAM.net>
> > > wrote:
> > >
> > > >Oops.
> > > >
> > > >Thanks for the correction (again???--I think you've corrected me on this
> > > >before--but I haven't learned!).
> > > >
> > > >Gord Dibben wrote:
> > > >>
> > > >> Did you mean .XLK files?
> > > >>
> > > >> .WBK are Word backup files
> > > >>
> > > >> But I see by Ken's response he's happy.
> > > >>
> > > >> Gord
> > > >>
> > > >> On Mon, 14 May 2007 11:46:31 -0500, Dave Peterson <petersod.TakeThisOut@verizonXSPAM.net>
> > > >> wrote:
> > > >>
> > > >> >To stop creating the .wbk files?
> > > >> >
> > > >> >File|SaveAs|Tool|General Options|Uncheck "always create backup"
> > > >> >
> > > >> >This setting is for for that one workbook/template. It's not an application or
> > > >> >user setting.
> > > >> >
> > > >> >Ken wrote:
> > > >> >>
> > > >> >> I used to know how to set this off using the template function. It has not
> > > >> >> happened in some time, but reappeared when my work PC got updated from Excel
> > > >> >> 97 to 2003.
> > > >> >> Can anyone out there shed a little light?
> > > >> >> Thanks.
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson