+ Reply to Thread
Results 1 to 9 of 9

AutoRecover not working?

  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    AutoRecover not working?

    Windows 7
    Excel 2003

    I have AutoRecover set to save my documents every 10 minutes.
    The "Disable AutoRecover for this workbook" boxes are not checked.
    The folder where Excel is allegedly saving my documents does not have my documents in it.

    Please tell me there's a good reason to not throw my computer out the window right now.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,284

    Re: AutoRecover not working?

    Autorecover saves a snapshot recovery file of some sort, not your whole file. Further, it's a hidden file. Even further, it only does it while the file is open. If you close your file normally, the autorecover file isn't needed anymore and goes away. It's only for recovery of an abnormal Excel termination.

    If your Excel file is called myexcelfile.xls, the recovery file will be called ~$myexcelfile.xls. Recovery files are stored in the same directory with the original file. You can see them if you enable "show hidden files" (I don't have Windows 7 so I'm not sure of the sequence to turn that on).
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: AutoRecover not working?

    "Show hidden files" is on.

    There are no backup files in either the folder where the excel files are saved or in the folder where AutoRecover says it is saving them.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,284

    Re: AutoRecover not working?

    Are you checking while a file is open in Excel?

  5. #5
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: AutoRecover not working?

    Yes.......

  6. #6
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: AutoRecover not working?

    Any other thoughts?

  7. #7
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: AutoRecover not working?

    Anybody else?

  8. #8
    Registered User
    Join Date
    09-02-2011
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: AutoRecover not working?

    Nobody else?

  9. #9
    Registered User
    Join Date
    12-07-2012
    Location
    Yorkshire
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: AutoRecover not working?

    OS: XP
    EXCEL 2003.
    Just had a situation needing to recover an unsaved excel file (power cut)and couldn't find it straight away.
    I had to enable "show hidden files and folders"
    FOLDER OPTIONS>VIEW>select SHOW HIDDEN FILES AND FOLDERS.
    Then go to C:\Documents and Settings\Philip(my name)\Application Data\Microsoft\Excel.
    In the EXCEL folder there where 3 .xar (hidden) files and 1 .xlb file.
    None had the name of my lost file.
    I selected VIEW>DETAIL to change the folder view so I could see "date modified".
    The file called " ~ar55B6.xar " looked a likely candidate so I double clicked and to my suprise it opened and it was the file I needed.
    Philip

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1