Excels auto recovery file is saving as a backup, how do i stop tha
 

The hidden recovery file is saving itself as an unhidden backup file when
ever is ave the workbook. is there a setting i do not know about for this and
how can i change this back?

Excels auto recovery file is saving as a backup, how do i stop tha
 

FileSave AsToolsGeneral Options.

Uncheck "always create backup"


Gord Dibben MS Excel MVP

On Fri, 20 Mar 2009 09:06:01 -0700, EPSCoR
wrote:

The hidden recovery file is saving itself as an unhidden backup file when
ever is ave the workbook. is there a setting i do not know about for this and
how can i change this back?

Excels auto recovery file is saving as a backup, how do i stop tha
 

Recovery as in autorecovery, right?

The recovery file isn't hidden. But it's usually stored in an out of the way
place that you wouldn't notice.

Make sure that the folder location is where you want it.

In xl2003 menus:
Tools|Options|Save
change the autorecover save location.

I've never changed mine (xl2003 and winXP home) and it points to:

C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\





EPSCoR wrote:

The hidden recovery file is saving itself as an unhidden backup file when
ever is ave the workbook. is there a setting i do not know about for this and
how can i change this back?

--

Dave Peterson

Excels auto recovery file is saving as a backup, how do i stop
 

is this the solution for excel 2007?

Excels auto recovery file is saving as a backup, how do i stop
 

To whom are you responding?

Dave or Gord?

If Gord.................Office ButtonSave AsExcel Workbook(or any format
you choose)

Lower left corner you will see "Tools" button.


Gord

On Fri, 20 Mar 2009 09:29:02 -0700, EPSCoR
wrote:

is this the solution for excel 2007?

Excels auto recovery file is saving as a backup, how do i stop
 

i am talking about the hidden file that appears in the folder of the file you
just opened. It turns itself into an exel back up file when ever you save the
workbook.

Excels auto recovery file is saving as a backup, how do i stop
 

What's the name of this hidden file?

EPSCoR wrote:

i am talking about the hidden file that appears in the folder of the file you
just opened. It turns itself into an exel back up file when ever you save the
workbook.

--

Dave Peterson