recovering workbooks
recovering workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: recovering workbooks

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way of recovering workbooks that crash. If this happens in Word when you re-open the file it does an Auto Recovery is there anything similiar in Excel 2000?.

    thanks

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is an autosave feature for download created by Jan Karel Pieterse. You can find it on this page:
    http://www.bmsltd.co.uk/MVP/MVPPage.asp

    I hope this helps.
    Kind regards, Al.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    Excel already has add in autosave which you can activate, if you have poper copy of Excel, and the disk may be needed, this can be set easy via tools bar.

    Also in VBA can be called fron ONTIME command...

    But to answer.

    Not many of us Exceller know Word and Excel are ver different in workings, forget word processings and maths spreadsheets, but in workings, i mean take save Word have very advanced technology to do this thus autoorecoveries files you can get, Excel DONT.

    The way Word saves is very powerful and complex it "ontheflys" saves excel dont, excel crunch saves so now recovery files.

    Assesnment Excel save is poor, remember to BACK up can be custon to set save as and back up at same time evey X minutes...

    ALWAYS BACK UP and ALWAYS ALWAYS hit Ctrl+S every 10 seconds or less (i really mean As Much A poss) as you work, or leave desk

    I have been told Microsoft have sorted emproved the technologys to save in Excel but XP has not got to Word 97 standards yet, ... maybe soon...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com