Losing work can be gutwrenching. AutoRecover for Microsoft Office is an amazing feature that allows you to recover Word, Excel and Powerpoint files. Let’s review how it works!
- Apr 16, 2018 The application Microsoft Excel quit unexpectedly. Mac OS X and other applications are not affected. Click relaunch to launch the application again. Click report to see more details or send a report to Apple.
- Excel file recovery my file lost data after i made a subtotal command, is there a way to recover my file in the point before i made my sub total command? This thread is locked.
Mac Excel Recovery
Microsoft Excel, the spreadsheet app, lets you create, view, edit, and share your files quickly and easily. Manage spreadsheets, tables and workbooks attached to email messages from your phone with this powerful productivity app from Microsoft. Work in data analysis, accounting, auditing, or oth.
The frustration of losing work to a computer crash is possibly one of the most disheartening feelings a professional can get hit with. Luckily technology has advanced in a way that has lessened the chance of losing work. Microsoft Word, Excel, and Powerpoint, for example, allow you to both repair your documents and spreadsheets as well as automatically take backups of your un-saved documents. Let’s review the feature as well as where you can find your lost work after a crash!
Excel For Mac
Recovering Word Documents
Microsoft Word is one of the most widely used programs within Office. So whether you’re a professional who needs their work back or a student desperately trying to recover their 10-page paper, it’s a lot easier to recover files with the last several versions of Microsoft Office 2016.
Open Word, Go to File > Open and Click the Recover Unsaved Documents button.
This should have your document in a folder ready to open. Typically with the newer versions of Word, when you restart from a crash the office program will actually ask you if you want to open unsaved documents.
Recovering Excel Workbooks and PowerPoint Presentations
The great thing about the current version of Microsoft Office is that the options are all very similar with slight differences for certain features and aspects, but recovering a document is the same process no matter what program you use. So whether you’re in Word, Excel, or PowerPoint the steps are the same, the names of the documents are different. In Excel, it’s a Workbook and in PowerPoint, it’s a presentation.
AutoRecover
Although enabled by default, I recommend everyone confirm AutoRecover is enabled and creating backups so you don’t have to take any extreme measures to recover your unsaved files in case of a computer crash or unexpected restart. To do this go to File > Options > Save and make sure that you check the box next to where it says Save AutoRecover information every 10 minutes. The default setting here is 10 minutes, however, feel free to change this to whatever you personally prefer. For me, 5 minutes is good enough to ensure that my files will be there after a crash.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.
Cause
There are two possible causes of this behavior:
- The oval button in the upper-right corner of the document was clicked. This button 'toggles' the display of toolbars on and off.
- There is an issue with Excel preferences.
Resolution
To resolve this issue, use the following methods in order.
Method 1: Make sure that toolbar display is not turned off
In the upper-right corner of the Excel window, click the oval button.
Note
When this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.
If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.
If Method 1 did not resolve the problem, try Method 2.
Method 2: Remove the Excel preferences
Step 1: Quit all applications
To quit active applications, follow these steps:
Microsoft Excel For Mac Os
- On the Apple menu, click Force Quit.
- Select an application in the 'Force Quit Applications' window.
- Click Force Quit.
- Repeate the previous steps until you quit all active applications.
Warning
When an application is force quit, any unsaved changes to open documents are not saved.
Step 2: Remove the Excel Preferences
To remove the Excel preferences, follow these steps.
Quit all Microsoft Office for Mac applications.
On the Go menu, click Home.
Open Library.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder. Click View, click Arrange by, and then select Name.
Look for a file that is named com.microsoft.Excel.plist.
If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
Quit all Office for Mac applications.
On the Go menu, click Home.
Open Library.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder.
Open the Microsoft Folder.
Look for a file that is named com.microsoft.Excel.prefs.plist.
If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
Close all Office applications.
On the Go menu, click Home.
Open Library.
Note
The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
Open the Preferences folder.
Open the Microsoft Folder.
Open the Office 2008 or Office 2011 folder.
Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash.
Microsoft Excel Recovery Mac
Note
If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.