Results 1 to 7 of 7

Thread: Do not open the MS Excel table 2016

  1. #1


    Member Since
    May 26, 2018
    Posts
    3
    Question Do not open the MS Excel table 2016
    Hi, the problem is like this, worked in the Excel spreadsheet before closing saved, turned off the computer. Resuming work in the program it turned out that was gone, all the formulas again, before exiting the program kept((( prompt please, whether probably to recover the data?

  2. #2

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    55,791
    Your sheet is likely gone unless you had a Time Machine backup that was running. It's very difficult to recover Office files unless you have a backup or make backups as you save. Word can make automatic backups by setting that in preferences, but as far as I can tell, Excel does not have that option.

    And welcome to our forums.

  3. #3

    IWT's Avatar
    Member Since
    Jan 23, 2009
    Location
    Born in Scotland, Worked in Scotland then England, Now live in Wales
    Posts
    4,264
    but as far as I can tell, Excel does not have that option.
    Charlie; not that it matters in this case, but I think XL does have an autosave function in Preferences:

    WORD

    S1-Word.png

    XL

    S2-XL.png

    Ian
    Ian

  4. #4

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    55,791
    The problem Ian is that Auto Recovery is hit and miss with Office. I have never gotten it to work. Word does have the option I mentioned above (and that you show) but Excel and Powerpoint depend entirely on Auto Recovery. And... pray tell, where is the Auto Recovery folder?

  5. #5

    IWT's Avatar
    Member Since
    Jan 23, 2009
    Location
    Born in Scotland, Worked in Scotland then England, Now live in Wales
    Posts
    4,264
    Yep, Charlie. I use PowerPoint a great deal and manually save every couple of minutes (Cmd + S). Even then, every 30 minutes or so, if it's a long study, I save the ppt and reopen as a new version. Quite often, if I've been working on a long project, I may have saved 4 versions in a morning. So, you're quite correct. And I hadn't thought about where these Auto-Recovered versions are saved.

    Big decision looming - which Office model to go for. I have 2011. Wait it out for the supposed 2019 product? 365 subscription? Will the current 2016 version last and, even then is it worth the cost - don't think so.

    Ah well, c'est la vie.

    Ian
    Ian

  6. #6

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Keller, Texas
    Posts
    55,791
    Same here Ian. I currently have and use Office 2011 when I need to exchange documents with others. Otherwise, I've switched to using the latest version of Pages for documents that I generate for my own use. I do have several large presentations that are done with Powerpoint and so far they seem to open and display well using Keynote.

    We are not sure what will happen with Office 2011 when the next version of macOS is deployed to the public. Apple seems to indicate that using 32 bit apps in the next version of macOS will work but there will be compromises. I'm still try to understand what Apple means by "compromises".

    MS has stated they are working on the next version of Mac Office but that could mean later this year or maybe even next year. Stand alone version? Subscription? Good questions.

  7. #7


    Member Since
    May 30, 2018
    Posts
    1
    Lightbulb error opening excel file
    Here are top 5 recommended methods that help you to recover data from corrupt MS Excel file:

    1: Try to repair it manually when MS Excel does not automatically starts File recovery mode.

    Click the Microsoft Office Button, and then click Open.
    Now select the corrupted workbook that you want to open.
    Click the arrow next to the Open button, and then click Open and Repair.
    Choose either Repair (to recover as much of the file data) or Extract data (to extract values and formula when repair process is not successful).
    2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & save Microsoft Excel files.

    3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements.

    4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements.

    5: Try 3rd party software
    Last edited by chscag; 05-30-2018 at 08:03 PM. Reason: Removed advertisement.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open Excel 2004 in Excel 2016
    By poppi in forum macOS - Operating System
    Replies: 3
    Last Post: 03-30-2018, 02:11 PM
  2. Excel 2016 for Mac
    By fak119 in forum macOS - Operating System
    Replies: 8
    Last Post: 06-19-2016, 09:45 PM
  3. Word doc with Excel table to Windows server
    By uklipse in forum macOS - Operating System
    Replies: 1
    Last Post: 02-25-2016, 06:10 PM
  4. Excel 2016 will only open Excel file as read only with Macros
    By mrj002 in forum macOS - Apps and Games
    Replies: 4
    Last Post: 09-14-2015, 01:16 PM
  5. Copying table into MS Excel for Mac
    By Trolle in forum Switcher Hangout
    Replies: 8
    Last Post: 08-19-2011, 08:38 PM

Posting Permissions

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