Excel 2007 Bug .XLK Auto Recovery

[Training Spec.]

Auto Recovery is suppose to save a temp file to C:\Documents and
Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel
Options to save the Auto Recovery files in that location. However, when I
close an Excel 2007 file (that I've saved in My Documents), there is an extra
file (in My Documents) with a "Back of" prefix followed by the filename.
Three issues: 1. It's not temporary, 2. It's not in the correct location and
3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to work as
advertized.

Thanks!

 

[Jim Rech]

The "Back of" file has nothing to do with Excel's auto recovery feature.
Auto recovery files are saved by Excel with some jibberish name (ending in
XAR) and they are only useable by Excel itself when it deems necessary,
i.e., after a crash. I don't know where the file you have came from.

 

[Training Spec.]

Thanks, Jim.

First, I want to correct my typo. I should have said "Backup of" instead of
"Back of".

But I still have the dilema. I see the .XAR temporary file in the correct
location and Excel 2007 removes it when I close Excel. However, can anyone
tell me how to stop Excel from creating an additional file (same name as
original) with the "Backup of" prefix in My Documents?
--
John

The "Back of" file has nothing to do with Excel's auto recovery feature.
Auto recovery files are saved by Excel with some jibberish name (ending in
XAR) and they are only useable by Excel itself when it deems necessary,
i.e., after a crash. I don't know where the file you have came from.



--
Jim

Auto Recovery is suppose to save a temp file to C:\Documents and
Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel
Options to save the Auto Recovery files in that location. However, when I
close an Excel 2007 file (that I've saved in My Documents), there is an
extra
file (in My Documents) with a "Back of" prefix followed by the filename.
Three issues: 1. It's not temporary, 2. It's not in the correct location
and
3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to work
as
advertized.

Thanks!

 

[Jim Rech]

However, can anyone tell me how to stop Excel from creating an additional
With the problem workbook active, open the File, Save As dialog. Then open
General Options from the Tools menu. Uncheck "Always create backup". I
think this has to be done individually for each workbook in which it has
been set.


--
Jim
| Thanks, Jim.
|
| First, I want to correct my typo. I should have said "Backup of" instead
of
| "Back of".
|
| But I still have the dilema. I see the .XAR temporary file in the correct
| location and Excel 2007 removes it when I close Excel. However, can anyone
| tell me how to stop Excel from creating an additional file (same name as
| original) with the "Backup of" prefix in My Documents?
| --
| John
|
|
| "Jim Rech" wrote:
|
| > The "Back of" file has nothing to do with Excel's auto recovery feature.
| > Auto recovery files are saved by Excel with some jibberish name (ending
in
| > XAR) and they are only useable by Excel itself when it deems necessary,
| > i.e., after a crash. I don't know where the file you have came from.
| >
| >
| >
| > --
| > Jim
message
| > | > > Auto Recovery is suppose to save a temp file to C:\Documents and
| > > Settings\[username]\Application Data\Microsoft\Excel. I set it up in
Excel
| > > Options to save the Auto Recovery files in that location. However,
when I
| > > close an Excel 2007 file (that I've saved in My Documents), there is
an
| > > extra
| > > file (in My Documents) with a "Back of" prefix followed by the
filename.
| > > Three issues: 1. It's not temporary, 2. It's not in the correct
location
| > > and
| > > 3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to
work
| > > as
| > > advertized.
| > >
| > > Thanks!
| > > --
| > > John
| >
| >
| >

 

[Training Spec.]

I don't believe it; it worked! Thanks!

Microsoft,
If you're monitoring this newsgroup, please fix Excel 2007. Users shouldn't
have to do this on some of their Excel files. Talk to the Word and PowerPoint
teams. This only happens in Excel.
--
John

With the problem workbook active, open the File, Save As dialog. Then open
General Options from the Tools menu. Uncheck "Always create backup". I
think this has to be done individually for each workbook in which it has
been set.


--
Jim
| Thanks, Jim.
|
| First, I want to correct my typo. I should have said "Backup of" instead
of
| "Back of".
|
| But I still have the dilema. I see the .XAR temporary file in the correct
| location and Excel 2007 removes it when I close Excel. However, can anyone
| tell me how to stop Excel from creating an additional file (same name as
| original) with the "Backup of" prefix in My Documents?
| --
| John
|
|
| "Jim Rech" wrote:
|
| > The "Back of" file has nothing to do with Excel's auto recovery feature.
| > Auto recovery files are saved by Excel with some jibberish name (ending
in
| > XAR) and they are only useable by Excel itself when it deems necessary,
| > i.e., after a crash. I don't know where the file you have came from.
| >
| >
| >
| > --
| > Jim
message
| > | > > Auto Recovery is suppose to save a temp file to C:\Documents and
| > > Settings\[username]\Application Data\Microsoft\Excel. I set it up in
Excel
| > > Options to save the Auto Recovery files in that location. However,
when I
| > > close an Excel 2007 file (that I've saved in My Documents), there is
an
| > > extra
| > > file (in My Documents) with a "Back of" prefix followed by the
filename.
| > > Three issues: 1. It's not temporary, 2. It's not in the correct
location
| > > and
| > > 3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to
work
| > > as
| > > advertized.
| > >
| > > Thanks!
| > > --
| > > John
| >
| >
| >

 

[Gord Dibben]

Every version of Excel I have worked with back to Excel 5.0 required you to
follow Jim's steps to always create a backup.


Gord Dibben MS Excel MVP

 

[Training Spec.]

The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .XLK)
which is one more than I think we need, especially when one (.XLK) never goes
away.

 

[Dave Peterson]

The .xar file is used for AutoRecovery. You shouldn't depend on it being there
as a backup.

It's created just in case excel crashes (or windows crashes). It should be
deleted if the original workbook closes without incident. If there's a crash,
you should see a prompt the next time you open excel that will allow you to
recover your work.

 

[Training Spec.]

I don't depend on it as a backup. I manually save my work every 15 minutes or
so. We also have tape backups on our server and, if it is very important, I
make a extra folder for my extra backup file. What I don't like is that Excel
2007 SOMETIMES decides that I want a backup (.XLK) and saves it where my
original file is saved. It clutters the folder.

 

[Dave Peterson]

Jim told you how you can turn off the creation of the backups.

 

[Training Spec.]

Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a
decision to SOMETIMES check 'make a backup'. I would like to check it when I
want it checked, not when Excel decides to check it.

 

[Dave Peterson]

I've never seen that option get turned on by excel.

Maybe you created a workbook from an existing workbook that had option checked.
Or maybe you used a template file that had this option checked. But I don't
believe that excel changed it for you.

Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a
decision to SOMETIMES check 'make a backup'. I would like to check it when I
want it checked, not when Excel decides to check it.