A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2009, 04:06 PM posted to microsoft.public.excel.setup
EPSCoR
external usenet poster
 
Posts: 3
Default 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?
  #2  
Old March 20th, 2009, 04:12 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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?


  #3  
Old March 20th, 2009, 04:26 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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
  #4  
Old March 20th, 2009, 04:29 PM posted to microsoft.public.excel.setup
EPSCoR
external usenet poster
 
Posts: 3
Default Excels auto recovery file is saving as a backup, how do i stop

is this the solution for excel 2007?
  #5  
Old March 20th, 2009, 04:42 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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?


  #6  
Old March 20th, 2009, 04:44 PM posted to microsoft.public.excel.setup
EPSCoR
external usenet poster
 
Posts: 3
Default 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.
  #7  
Old March 20th, 2009, 05:49 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.