You can recover unsaved Office files for Mac with the Terminal command but have to apply your technical sophistication to prevent ambiguity. Furthermore, to recover saved files lost due to accidental deletion, unintentional formatting, and corrupt storage devices, Stellar Data Recovery Professional for Mac is the most effective method. Power outage, also known as power failure or blackout, is a short or long term loss of electric power that results in computing system failure and subsequent data loss. In order to prevent the short-term power outage, use of uninterrupted power supply (UPS) is recommended. Apr 16, 2018 Troubleshooting damaged documents in Word for Mac. Press the power button. When you hear the startup tone, immediately hold down the SHIFT key. The AutoRecovery feature in Word for Mac tries to automatically recover text from a document that was open when Word for Mac crashed. When you restart Word for Mac after the program.
- 2018 Word For Mac 15.39 Recover After Power Failure Flashlight
- 2018 Word For Mac 15.39 Recover After Power Failure Alarm
FonePaw - Solution - Recovery - How to Get Back the Lost Excel Files
Computer crash and power failure occur frequently and unexpectedly. If you happen to be working hard on an Excel workbook but forget to save it in time when Excel stops working; or if you accidentally close the file without saving it, it would be a big tragedy. But, thankfully, Microsoft Excel has built-in AutoSave and AutoRecover features which can help you avoid losing important data. Follow us to see how these features recover unsaved excel files on Excel 2016/2013/2011/2007/2003.
We will also introduce a professional data recovery that can help you out when Excel's built-in features fail to work recover excel files that are not saved. A good habit of saving Excel files on time and preparing a backup copy will also work to your advantage.
Recover Unsaved Excel Files via AutoRecover
Microsoft Excel now has a built-in AutoRecover feature which can help users retrieve the files if Excel closes unexpectedly due to power failure or computer crash. It can restore the unsaved file to the last saved version. When Excel closes unexpectedly without saving your work, don't worry. Next time you run Excel, you can see the retrieved file in the Document Recovery pane.
But it should be noted that Excel AutoRecover is not workable unless you have saved the file at least once. If you have never saved the file before Excel accidentally stops working, the file will not be recovered.
Locate and Recover Unsaved Excel Files via AutoSave Folder
With AutoSave, another built-in feature of Microsoft Excel, a newly created excel file can be saved automatically in a preset interval. Even if users forget to save the file, they will not totally lose it when something goes wrong.
Like AutoRecover, AutoSave is turned on by default in Excel, and it also allows users to define the interval of auto saving and the location of the saved excel file. Once you close Excel documents without saving, the first thing that you should do when reopen Excel is to recover unsaved Excel files from AutoSave folder.
To reach the auto-saved Excel files, do as the following steps:
Step 1: Click File > Open > Recent Workbooks.
Step 2: Go to the Recover Unsaved Workbooks.
Step 3: Select the needed file and click Open.
Step 4: When the document open in Excel, remember to click the Save as a button in the yellow bar above your worksheet and save the file to the desired location.
Tip: Change Excel AutoSave Location and Settings
You can decide where to save autosave files in Excel and also how long should Excel autosave a document.
Step 1: Go to Excel autosave settings on your computer.
-
Microsoft Excel 2013 and 2016 AutoSave Location:In Excel, click File > Options> Save.
-
Microsoft Excel 2007 AutoSave Location: Click the Microsoft button > Excel >Save.
Step 2: Make sure both the Save AutoRecover information every X minutes box and Keep the last autosaved version if I close without saving box are selected.
Step 3: In the Save AutoRecover information every X minutes box, you can shorten or lengthen the interval as you like. In the AutoRecover File Location box, you can also decide where to put your saved file.
AutoSave Not Working? Restore Unsaved Excel Files in This Way
Though AutoSave is a very useful function, like all the other built-in features, it does not work well all the time. In fact, we have heard users complain from time to time that, even though they have seen the taskbar shows that Excel auto-saved their file many times, they have no luck in getting the latest saved version. That would be a nightmare if your efforts devoted to work are in vain. But, don't be upset or panicked, a professional data recovery, FonePaw Data Recovery, for example, can be your great help. The program can recover lost or deleted Excel files, word documents and more from your Windows computer. In just a few steps, you can have your lost excel file back:
Step 1. Download and Install FonePaw Data Recovery
DownloadDownload
Step 2. Select 'Document' and Start Scanning
In the homepage, you can select file type and hard drive for the data recovery to scan. If you want to find your lost Excel workbook, click 'Document' and the hard drive where you have lost it, for example, Disk (C:) , then click 'Scan' to start the process.
Step 3. Preview The Scanned Results
FonePaw Data Recovery will present the scanned files in two lists, one is type list where all the data are categorized according to their formats; the other is Path list in which the founding documents are classified by their location.
In Type List, Select '.xlsx' . If there are '.xlk' documents, you should also select them, because '.xlk' document is the backup copy of Excel file.
Step 4. Recover The Lost Excel File
When you find the lost Excel file, select it and click Recover, then it will be safely put back to your device.
Tips on Saving Excel Files
Though AutoSave and AutoRecovery are great features; data recovery is also a good tool, they are just temporary remedies. A good habit of saving important data and an awareness of preparing a backup of your Excell files can save you much trouble in the long run. Follow our bonus tips on how to save Excel files.
Shorten The Interval of Excel AutoSave
The amount of new information that the recovered Excel file contains depends on how frequently Excel auto saves the file. If your file is set to be auto-saved every 10 minutes, your newly input data of the last 8 minutes won't be contained when encountering a power failure or computer crash. Therefore, to save as much information as possible, you can enter a small number in the minutes box. The more frequently your Excel worksheet is saved, the more chances you will recover a complete file.
Backup Excel Files
A less commonly known feature of Excel is Auto Backup. In fact, this is a very useful function, for it can not only help you avoid losing important data, but it also allows you to have access to the previously saved version of your workbook. If you enable this function, the moment when you save the file, an Excel backup file will also be created with a '.xlk' extension. You don't have to worry that your file might disappear, for you can always refer to the backup.
Since the backup file is always one version behind the current version, if you make a bunch of changes to the file, save it but suddenly change your mind and want to get back to the previous version, you could just open the backup file, too. This will save you much trouble of rewriting the data.
To enable this feature, do as the followings:
Step 1: Go to File> Save as >Computer on Excel.
Step 2: Click the Browse button.
Step 3: When the Save as dialog window pops up, click the drop-down button of the Tools button which is at the lower right corner.
Step 4: Among a couple of options, select General Options> Always create backup.
Step 5: Click OK. Now a backup copy will be created automatically every time you save your file.
After reading this article, do you have a better understanding of how to recover unsaved Excel files? Remember, if they fail to work, you can turn to FonePaw Data Recovery for help. And don't forget to form a habit of saving files in time and always preparing a backup!
Data Recovery
Professional Data Recovery wizard works for deleted files recovery on your Windows computer.
- Hot Articles
- PSD Recovery: Easiest Way to Recover Unsaved Files in Adobe Photoshop
- MS Office Recovery: Recover Deleted Office Files
- Recover Deleted HTML/HTM Files from Laptop (20K Users Tried)
- How to Recover Permanently Deleted Files in Windows 10
- Is There a Way to Recover Lost Word Document?
- PDF Recovery: How to Recover and Repair PDF Files
Important Update: Microsoft Office 2019 for Mac has now been released. We strongly recommend upgrading to Office 2019 as it fixes many of the problems users commonly experience in Office 2016.
If you’re having problems with Office 2016 for Mac especially Outlook 2016 crashes, Word 2016 crashing or Office 2016 crashing in Sierra, High Sierra or Mojave here’s a comprehensive list of solutions to repair Office 2016 on Mac.
If you need a quick fix or are in a hurry, remember that if you’ve got an Office 365 for Mac subscription, you can use the online version of Office 2016 until you’ve managed to fix the desktop version of Office 2016 on your Mac.
Alternatively, you can also install Windows on your Mac using Parallels to use the Windows version of Microsoft Office which is more stable than the Mac version.
You May Also Like:
If you’re desperate to open your Outlook mails but can’t because Outlook keeps crashing, you may also find our guide on ways to open Outlook emails on Mac without using Outlook useful too.
With this in mind, here’s a list of 13 ways to fix Office 2016 for Mac when it keeps crashing.
1. Run Microsoft AutoUpdate
One thing you can guarantee with Microsoft software on Apple products is that there will always be glitches and problems, particularly when it comes to a huge office suite like Office. Most of the problems Mac Office users have regard various types of Outlook and Word crashes on Mac especially Outlook 2016 crashing on startup or hanging.
Microsoft has already issued fixes for some of these via Microsoft AutoUpdate for Mac so we recommend you run that first by opening any Microsoft Office program, going to the Help Menu at the top of the screen and selecting “Check for Updates”.
Likewise, Apple has also issued updates for El Capitan users which you can get by opening the Mac App Store and clicking on the Updates button at the top of the screen. If you’re having problems with Office 2011 crashing in El Capitan, we also show you how to fix Office El Capitan problems in the 2011 version. We’ve attempted to address all of the most common Office 2016 for Mac crashes here but if we’ve missed anything, let us know in the comments and we’ll try to help. This article starts with Outlook fixes and then moves on to Word so scroll down if it’s just Word 2016 you’re having problems with.
The other important thing to note is that Office 2016 for Mac only works with OS X 10.10 Yosemite or higher – it does not work with OS X 10.9 Mavericks or lower so make sure you are definitely running OS X 10.10 Yosemite, OS X 10.11 El Capitan, macOS Sierra 10.12 or macOS 10.13 High Sierra before proceeding. Before trying any of these fixes, we also recommend uninstalling any anti-virus software you may be using on your Mac. Kaspersky Internet Security for Mac and Kaspersky Total Security for Mac in particular can sometimes conflict with apps and for those on enterprise networks, we also recommend uninstalling Kaspersky Network Agent and Kaspersky Endpoint Security if you’re running them and then try opening Office 2016 on Mac again.
2. Rebuild Office 2016 For Mac Database
In Office 2011, a common way to fix this was to rebuild the Office 2011 database (also known as creating a new identity). However, Microsoft has removed this feature in Office 2016 for Mac claiming Office database rebuilds are now done automatically on Mac. Office 2016 for Mac will only prompt you to rebuild the database if it encounters a problem but this doesn’t always work anyway and you risk losing all of your mail if it doesn’t repair properly:
The way round this is to create a new Profile in Office 2016 for Mac instead (previously called an “Identity” in Office 2011). Note that if you use Microsoft Exchange, creating a new profile will delete any data that has not yet been synchronized with Exchange including contacts so it’s advisable to backup any local data in Outlook on your Mac.
Here’s how to create a new identity in Office 2016 using El Capitan, Sierra and High Sierra:
- Open your Applications folder and find Microsoft Outlook
- Hold down the CTRL key and then click on Microsoft Outlook to see the contextual menu and select “Show Package Contents”
- In the Contents > SharedSupport folder, double-click on Outlook Profile Manager (which was previously called Database Utility in Office 2011).
- In the Outlook Profile Manager window, click on the (+) button to give the new profile a name.
- Finally, click the Options button and click Set as Default
You can also try this for Office 2011 although it seems less likely to work regarding problems with El Capitan. In Outlook 2011, you simply hold down the Option key when launching Outlook to open the Database Utility to create a new Identity (now called “Profiles” in Office 2016).
3. Outlook 2016 Crashes Sending Mail
If you’re finding that Outlook 2016 is crashing or freezing every time you try to send mail or Outlook 2016 for Mac won’t send email, then the easiest solution is simply to create a second identical Outlook account and then delete the first one. Here’s how to add a new account or profile in Outlook 2016.
- On the setup page, click Add Account. Or you can click the Tools tab at the top of Outlook and click on Accounts:
The Outlook 2016 account wizard will then start:
- Select Add Account and then the account type you want – either Exchange or Office 365 to add your email account. Click Other Email to add your personal email account such as Outlook web account, Gmail, Yahoo mail etc.
- Enter your account information and click Add Account. Click the “configure automatically” check box at the bottom which will automatically enter the right technical details for your account. If this doesn’t work however, you can enter the details manually for an Outlook account using the details below. For Gmail and other providers, you’ll have to Google for the right details:
-
Fields IMAP Incoming server imap-mail.outlook.com Port for the incoming server 993 Outgoing server smtp-mail.outlook.com Port for the outgoing server 587
You then simply import all of your mail from your old account into the new one. To do this you go back to the new account wizard but instead of clicking Add Account, you click Import instead. You then simply select the Outlook account on your Mac to import and all your data will be transferred automatically. You can delete the old account in account manager but we strongly advise making a backup of it before doing so.
4. Outlook 2016 Crashes On Startup
If you find that Outlook keeps crashing when you try to open it or keeps giving you an “Office 365 Active Subscription” error message, the solution is to delete the Outlook 2011 preferences file from your current installation of Outlook on your Mac. Don’t worry, this won’t affect Outlook 2011 when you want to go back to it – it will continue to work as normal.
1. Search for Terminal on your Mac by going to the spyglass in the top right corner and searching for “Terminal”:
2. In terminal type: defaults delete com.microsoft.Outlook and press Enter: 3. Then type: killall cfprefsd to kill the cached preferences and press Enter: 4. Relaunch Outlook and you should find it works again. If you were attempting to import an Outlook 2011 PST file before the crash and Outlook prompts you to import again, you can skip it because the PST will already have been imported previously. If your mail isn’t there, go to File – Import and then browse to your Outlook 2011 PST file. This fix will also start syncing Outlook 2016 with Office 365 and you should start to see your calendar and other data synchronizing.
5. Outlook 2016 With Exchange Errors
If you’re having problems adding an Exchange account to Outlook 2016 then it’s probably because your version of Exchange is not supported. The error message will usually be something like:
The data contains an exchange 2010 SP1 or older account
or
EXC_BAD_ACCESS
or
error -3253 … Connection to the server failed or was dropped
Office 2016 For Mac only supports Exchange 2010 SP2 or higher – meaning you’ll have to upgrade Exchange if you’re still using Exchange 2010 SPP1 or Exchange 2007.
6. Update Microsoft Error Reporting
If you’ve just upgraded to Office 2016 on your Mac, you also need to make sure that Microsoft Error Reporting is updated to at least version 2.2.9. If not, the older version of Microsoft Error Reporter will keep conflicting with Outlook 2016 and make it crash. To update, simply go to the Apple logo in the top left corner of your Mac and select “Software Update…” and install the available updates.
7. Outlook Hangs Or Crashes Importing PST Files
This is unfortunately a recurring problem with Outlook on Mac. Large PST files, especially those more than a few GB, tend to send Outlook into a tailspin. The best advice is to go away and have a cup of tea and leave Outlook to get on with it as it can take a long time. However, if you eventually end up with this message:
Outlook has encountered a problem and needs to close
Sometimes the solution for this is to download the latest update to Outlook or Office for Mac. However, since no updates are available yet for Office 2016 for Mac, there’s not much you can do until Microsoft issue one. If you haven’t already, you can try compacting the PST file by going to Account Settings – Data Files and Compact Files. There are also some third party apps that split PST files but they only work on PC.
8. Outlook 2016 Won’t Import Rules From Windows
Office 2016 on Mac seems to have a problem importing rules from Outlook for Windows. Unfortunately, there’s no solution for this other than to enter them manually but you can speed things up by using categories to enter new rules in Outlook 2016.
9. Outlook Won’t Sync With Outlook.com, iCloud etc
Unfortunately Outlook 2016 won’t sync Contacts and Calendars with Outlook.com, iCloud or Gmail. This is because Outlook for Mac still does not support CalDAV or CardDAV (although Outlook for Mac does support iCloud Mail). This is a known Office 2016 for Mac syncing bug that Microsoft are aware of but it remains to be seen whether it will be fixed in the final release.
These are the most common Outlook 2016 crashes on Mac but here are a few other Office 2016 for Mac problems you may be struggling with.
10. OneDrive For Business Document Cache Error
If you’re using Office 2016 with OneDrive For Business and are receiving the error:
A problem occurred while accessing the office document cache. Do you want to repair this problem?
Whether you choose to try and repair the problem or not, you’ll probably find that OneDrive For Business will then hog your Mac’s CPU and crash. To fix this, you must simply delete your OfficeFileCache.
1. Close OneDrive For Business
2. Go to: ~/Library/Group Containers/UBF8T346G9.Office/Microsoft/AppData/Microsoft/Office/15.0/OfficeFileCache
If you have trouble finding it, the easiest way is to go to Finder and select Go in the Menu Bar, hold down the ALT key and you will see the Library folder appear:
3. When you’ve found the OfficeFileCache file, delete it, restart OneDrive For Business and it should work.
11. How To Fix Word 2016 Crashes
If you’ve been having problems with Word 2016 crashing on your Mac, then there’s actually a simple solution to fix most of them. There are a variety of problems and issues in Office 2016 For Mac that mean Word 2016 keeps crashing, some with error messages and others that just display the spinning beach ball of death and require you to Force Quit. Some people find that simply selecting or editing text in Word 2016 makes it freeze and crash while for others it won’t launch or startup. The frustrating thing for Mac users is that many of these bugs didn’t affect the Preview version of Office 2016 For Mac and only started to emerge once the final version was released. The solution usually involves updating Word via Microsoft Update but it depends on the type of problems you are experiencing.
If Word freezes or crashes when opening a file and you’re getting the message: “Unexpected critical error: Can’t open program”:
Or if you’re seeing a “Can’t load Visual Basic For Applications” error:
Or if you’re experiencing an error a few minutes after starting it such as this “Microsoft Word has encountered a problem and needs to close” error then there a few ways to fix all of these problems.
The first and most common solution is to run Microsoft AutoUpdate from within Office 2016 for Mac. Simply go to the “Help” menu and then select “Check For Updates” and many of the issues have already been solved by Microsoft.
2018 Word For Mac 15.39 Recover After Power Failure Flashlight
This cause of the bugs usually range from simple conflicts with other applications to an inability of Word to open diacritic accent characters and degree symbols in the names of files (basically unusual, non-standard or Chinese characters or letters) which Word 2016 can’t handle in certain cases. Some crashes are also due to corrupted template or preferences files which if not solved via software update, can be fixed by creating a new user profile. Finally, some bugs are simply due to trying to directly open Word files from online storage solutions such as Dropbox.
2. If this doesn’t work for you and you find that Word still crashes when you try to open a document, try opening Word first and then opening the file in it rather than double clicking on a file to open it. This simple workaround seems to have worked for some users at least.
3. If you’re experiencing crashes when selecting “Save” or “Save As…” and are using a developer preview of OS X 10.11 El Capitan, then simply update the developer preview to the latest version and the bug should be fixed.
If none of this works and you desperately need to edit a Word document to meet a deadline, we strongly recommend using Apple’s equivalent of Word which is Pages and can open Word .docx documents. Alternatively check out our article on the Best Alternatives to Word On Mac.
12. Will Office 2016 Copy Over Office 2011?
No. You can safely install Office 2016 and it will not copy over or mess-up your Office 2011 files. Office 2011 uses a different location for files: ~/Documents/Microsoft User Data/Office 2011 Identities while Office 2016 Preview uses ~/Library/Group Containers/UBF8T346G9.Office/
13. If You Still Haven’t Found A Solution
Microsoft claims to be aware of the problems with Office 2016 for Mac and has promised to issue fixes soon. However, if you can’t wait until then, we recommend contacting Microsoft Office Support or you can report problems from within Office 2016. If you’re experiencing regular crashes in Office 2016, it helps if you paste in the the crash stack or error report so that Microsoft can pinpoint the exact problem. If you don’t get an error report because Outlook or Office just freezes or hangs, go to your Applications folder and open Activity Monitor and then take a snapshot of a Sample Process by selecting the small Settings cog at the top of the Activity Monitor window:
You can also give feedback to Microsoft from within Office 2016 by selecting the small smiley face in the top right corner and explaining your problem or pasting in any crash reports or logs that you have.
If none of these fixes repair Office 2016 on your Mac and remember that if you have a subscription to Office 365, you can check your mail using the web version of Outlook and Office 365.
One last word of advice. If you need a reliable long term backup solution to problems with Office on your Mac, the only other solution is to install Windows on Mac and install Microsoft Office 2016 on that. It’s a bit of hassle to install and setup but nowadays you can run Windows 10 on Mac for free.
If however Office 2016 for Mac crashes all the time and you’ve simply had enough of Microsoft products, here we show you how to completely uninstall Office 2016 for Mac.
2018 Word For Mac 15.39 Recover After Power Failure Alarm
We hope these tips have helped you stop Outlook 2016 and Word 2016 from crashing on your Mac. If you’re struggling with other bugs or problems with Office 2016 For Mac or, let us know in the comments below and we’ll try to help.