Gaaaaaaaaah! Durn you to heck, Excel!

Discussion in 'Random Ramblings' started by sfw2, Jan 3, 2012.

  1. sfw2

    sfw2 Global Menace

    So, I'm still at work. I've been updating an excel worksheet all day. I'm up to 69190 rows. I can't remember the last time I saved it. It's "Not Responding", and I'm scared to exit.

    [​IMG] [​IMG]

    I want to go home!

  2. Glenmar

    Glenmar Songster

    Jan 17, 2011
    [​IMG] I know the feeling [​IMG]
  3. fuzziebutt

    fuzziebutt Songster

    Mar 9, 2009
    Bless your heart!!
  4. animalsRawesome

    animalsRawesome Songster

    Apr 12, 2011
    Did it save? I hope everything turns out OK. [​IMG]
  5. ChickenPeep

    ChickenPeep Faith & Feathers

    May 1, 2011
    Olathe, Kansas
    So sorry! [​IMG] I know how you feel!

  6. debilorrah

    debilorrah The Great Guru of Yap Premium Member

    If it is hung up, and hopefully you have auto save set for every 10 minutes, it should recover when you re-boot. I have several like that, one that has to be printed on plotter paper to get the whole thing!!!!
  7. animalsRawesome

    animalsRawesome Songster

    Apr 12, 2011
    Ummm, not to change the subject, but how do you set it to autosave every ten minutes? [​IMG]
  8. Fierlin1182

    Fierlin1182 powered-flight

    Aug 26, 2011
    Good luck. I hope the autosave pulls through for you. [​IMG]
    Once I was in hysterics because I thought I'd lost a project I didn't save when my laptop crashed, but it was there when I logged back in after reboot. I didn't even know I HAD autosave on that laptop, so you might just be in luck. [​IMG]
  9. BarkerChickens

    BarkerChickens Microbrewing Chickenologist

    Nov 25, 2007
    High Desert, CA
    Quote:Depending on the version you have...
    Click on round "Office Button" just to the left of Home.
    Click on Excel Options at the bottom of the pull down.
    On the left hand side, there is a tool bar showing several options. Click on Save.
    On the right, the save options pop up.
    The first one listed is "Save Workbooks". Make sure the "Excel Workbook" options is selected to save it in the current format (or adjust accordingly). Make sure the AutoRecover box is checked and select the time interval you want it autosaved. You can also adjust the AutoRecover file location if you like.

    It is good to be in teh habit to save anyways as the autorecover is not saving the original file, but rather a backup file in case your file becomes corrupt, Excel or computer fails, etc.

  10. debilorrah

    debilorrah The Great Guru of Yap Premium Member

    Quote:Depends on your version.

BackYard Chickens is proudly sponsored by