Excel for Mac: how to recover unsaved file?

Discussion in 'Mac Applications' started by JohnDohe, Aug 12, 2017.

  1. JohnDohe

    JohnDohe New Member

    Joined:
    Aug 12, 2017
    Messages:
    3
    Likes Received:
    0
    OMG!!

    I spent days working on an Excel for Mac worksheet (version 15.33).

    I'd left it, open, on my MacMini (late 2012; Sierra 10.12.6) for days.

    I'd made countless changes and customizations to it in the interim.

    Today I went to close it and . . . chose NOT to save it !!!

    ARRGGHH!!!

    How do I get it back?

    And BTW, how do I know which version of Excel for Mac I'm using?

    Thanks!
     
    JohnDohe, Aug 12, 2017
    #1
    1. Advertisements

  2. JohnDohe

    Cory Cooper Moderator

    Joined:
    May 19, 2004
    Messages:
    4,832
    Likes Received:
    130
    Hello and welcome.

    When Excel is running, click Excel > About Excel from menu bar to find out which version you have.

    Unfortunately, if you didn't save it prior to closing it, then you have probably lost all of your work. You could check in Excel > File > Open Recent to see if it may be there. This is one reason I prefer Google Sheets over Excel - when you stop inputting information, it automatically saves the file to your Google Drive.

    Do you happen to have Time Machine running?

    C
     
    Cory Cooper, Aug 12, 2017
    #2
    1. Advertisements

  3. JohnDohe

    JohnDohe New Member

    Joined:
    Aug 12, 2017
    Messages:
    3
    Likes Received:
    0
    Hi,

    Here's what I've got:

    Screen Shot 2017-08-12 at 1.22.09 PM   Saturday  8-12-17.jpg Screen Shot 2017-08-12 at 1.22.17 PM   Saturday  8-12-17.jpg
     
    JohnDohe, Aug 12, 2017
    #3
  4. JohnDohe

    JohnDohe New Member

    Joined:
    Aug 12, 2017
    Messages:
    3
    Likes Received:
    0
    Excel > File > Open Recent shows the file, and it opens,
    but all the formatting, coloring, etc are gone. Just the
    text is there.

    No Time Machine.

    How would Time Machine have saved it??
     
    JohnDohe, Aug 12, 2017
    #4
  5. JohnDohe

    Cory Cooper Moderator

    Joined:
    May 19, 2004
    Messages:
    4,832
    Likes Received:
    130
    Well, at least the text is there...you must have saved that at some point.

    If Time Machine were running, you might have been able to recover a recent version due to Excel's "auto-save" version, but probably not likely It is extremely critical, especially with Microsoft Office apps, to save frequently and even save, close, and reopen at times. Office is notorious for crashing and losing all unsaved work.

    We strongly suggest that you purchase an external hard drive and setup Time Machine to perform routine backups. It's not a question of if, but when a hard drive will fail. We'd hate for you to lose all of your data at some point.

    C
     
    Cory Cooper, Aug 12, 2017
    #5
  6. JohnDohe

    honestone VIP Member

    Joined:
    Sep 17, 2014
    Messages:
    2,893
    Likes Received:
    123
    Location:
    Kent, WA (just south of Seattle, WA)
    Office 2016 (and of course Excel) is now at V15.36. You can get the update/updates from here:

    https://support.office.com/en-us/ar...542-9954-7e3209681a41?ui=en-US&rs=en-US&ad=US

    While Time Machine is fine, if you do need to do a complete recovery, it is time consuming. Either SuperDuper! (http://www.shirt-pocket.com/SuperDuper/SuperDuperDescription.html), or Carbon Copy Cloner (https://bombich.com/) are better, as both of them make a bootable backup/clone of your system. I use SuperDuper!, and when either I am upgrading to a new Mac OS, doing a "within the same" Mac OS upgrade, or need to do a complete recovery (very rarely happens), it is very smooth with a SuperDuper! backup.

    But be that as it may, Cory is definitely correct. You really need to start making backups to an external device.

    Finally, with Office 2008, Office 2011, and now Office 2016, I have never had an issue with them crashing. In fact, given how often I use Outlook 2016 for my EMail needs, it never crashes. Of course, I suspect it helps that I make a concerted effort to keep my Macs "lean, mean, and clean".

    BTW, I also have a late 2012 Mac Mini, along with a mid 2013 13" MacBook Air (and running OS 10.12.6 on both). Both machines run fine for me, and of course all my apps do too.
     
    honestone, Aug 12, 2017
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. YoJeff
    Replies:
    1
    Views:
    555
    Cory Cooper
    Jun 21, 2016
  2. Muvuth
    Replies:
    1
    Views:
    318
    Cory Cooper
    Sep 4, 2016
  3. Ormond
    Replies:
    8
    Views:
    551
    honestone
    Oct 19, 2016
  4. Cape hack

    How to convert photos to jpeg in Sierra

    Cape hack, Oct 20, 2016, in forum: Mac Applications
    Replies:
    1
    Views:
    970
    Spawn_Dooley
    Oct 21, 2016
  5. davidlaing

    How to make a table in Word for Mac 2011

    davidlaing, Jan 31, 2017, in forum: Mac Applications
    Replies:
    14
    Views:
    217
    davidlaing
    Feb 1, 2017
  6. DavidSr
    Replies:
    10
    Views:
    202
    Cory Cooper
    Feb 19, 2017
  7. mprusse
    Replies:
    1
    Views:
    341
    Jimmy Martin
    Jun 7, 2017
  8. Ccris

    How to recover deleted notes?

    Ccris, Jun 20, 2017, in forum: Mac Applications
    Replies:
    3
    Views:
    198
    Ccris
    Jun 21, 2017
Loading...