Several Windows users have been reaching us with questions after being unable to save the modifications they make on an Excel table. As it turns out. Part 3: How to Repair Excel Corrupted/Damaged by Various Reasons. Different software is available for repairing Microsoft Excel but we recommend the highly effective Stellar File Repair software. With the excel sheet opened, navigate to the ‘View’ Tab, click on the ‘Macros’ button. Now enter the macro name say “FetchLinks” (without quotes) and hit the create button. This will open the Excel VBA editor, simply paste the below code after the first line. Dim aLinks As Variant. You can fix this problem by opening the Microsoft Database Utility and running a Rebuild. In order to open Microsoft Database Utility open Finder and go to Applications folder. Then look for Microsoft Office 2011 folder and go to Office sub folder. Run Microsoft Database Utility.app.
Are you unable to open the Microsoft ExcelApplication on Mac OS X Yosemite (OS X 10.10)? OR Microsoft Excel Quit Unexpectedly on Mac? Or getting an error message “The application Microsoft Excel quit unexpectedly. Mac OS X and other applications are not affected. Click re-launch, to launch the application again. Click report to see more details or send a report to Apple”?
If you are dealing with the above-given scenarios and want to get rid of Microsoft Excel Quit Unexpectedly Mac issue then you are at the right place. Here, we will discuss several solutions that will help you to fix Microsoft excel quit unexpectedly Mac.
This annoying situation may appear when the user tries to open the Microsoft Excel on Mac OS X Yosemite (OS X 10.10) and the situation becomes worse when Microsoft Excel refuses to start after crashing.
Not only excel but you may also face trouble while trying to open the other Microsoft Office apps like MS Word, MS Powerpoint. They start throwing an error “Microsoft office Quit unexpectedly on Mac” each time when a user tries to open MS office on OS X Yosemite.
You can easily solve this error without the need of any professional experience and help you to access your document without losing data. Microsoft provides effective solutions to fix this problem. All the solutions discussed under this blog are resourced by Microsoft officials.
So let’s start solving this error by applying the given solutions one by one.
Go with the solutions depending on the version of your Microsoft Excel for Mac.
Fixes for Excel 2016 for Mac
Fix 1: Quit all programs and close all windows
Step 1: From the Apple menu, click on the Force Quit option.
Step 2: You have to choose an application in the “Force Quit Applications” Window.
Step 3: Then click on the Force Quit.
Fix 2: Remove Excel preferences and Office settings
Step 1: First you have to close all the Microsoft Office programs.
Step 2: Now, with the help of Go menu, navigate to the root/hidden Library folder.
Note: If you are using the Mac OSX Yosemite then the Library folder is hidden by default. To unhide this folder, hold down the OPTION key while clicking on the Go menu.
Step 3: Click on the Group Containers folder to open it and search for a folder whose name contains “.Office,” at its end and then open it.
Step 4: After opening this folder, search for the Com.microsoft.officeprefs.plist file.
Step 5: Now, you have to erase this file by dragging it to the trash. Deletion of Com.microsoft.officeprefs.plist file will delete the Office preferences.
Step 6: At last, reboot the MS Office Application, and check for the issue.
In case you are still unable to fix the issue, then you should delete the entire folder “.Office”
This will erase all the preceding settings and preferences that were set for all applications.
Fix 3: Run a Clean Restart
In order to run a clean boot or start up Mac in safe mode, follow the below given step:
Step 1: Restart your Mac and without delay press and hold the Shift key. You will see an Apple logo on your display.
Step 2: Now, release the Shift key when the login window appears. In case, your startup disk is encrypted with FileVault then you have to log in twice.
Step 3: In the safe mode, if all OK and you are using the Microsoft office without any error then it means that the background programs are conflicting with the Office for Mac. In order to detect that which one is conflicting with the MS office on Mac you should remove the installed apps one by one and check for the error.
Fix 4: Remove and then reinstall Office
In order to uninstall and reinstall Microsoft Excel on Mac, follow the below-given steps:
Step 1: navigate through the Finder > Applications.
Step 2: Press the Command +click to choose all of the Office for Mac applications.
Step 3: Select the Microsoft office and press the Ctrl+click then click Move to Trash.
In order to install the Office again, you should follow: How to download and install or uninstall Office 2016 for Mac
Fix 5: Use the “Repair Disk Permissions” Feature
With the help of Repair Disk Permissions option, one can easily troubleshoot permissions problems in Mac OS X 10.2 or later on versions. Follow the below-given steps:
Step 1: Click on the Go menu and then click Utilities.
Step 2: Run the Disk Utility app.
Step 3: Here you have to click on the primary hard disk drive for your computer.
Step 4: From the First Aid tab, click Repair Disk Permissions.
Note: This Disk Utility App repairs only apps that are installed via Apple.
Fixes for Excel for Mac 2011
Fix 1: Quit all programs and close all windows
Step 1: From the Apple menu, click on the Force Quit option.
Step 2: You have to choose an application in the “Force Quit Applications” Window.
Step 3: Then click on the Force Quit.
Fix 2: Run a clean Restart
Step 1: Restart your Mac and without delay press and hold the Shift key. You will see an Apple logo on your display.
Step 2: Now, release the Shift key when the login window appear. In case, your startup disk is encrypted with FileVault then you have to log in twice.
Step 3: In the safe mode, if all OK and you are using the Microsoft office without any error then it means that the background programs are conflicting with the Office for Mac. In order to detect that which one is conflicting with the MS office on Mac, you should remove the installed apps one by one and check for the error.
If the problem is still not fixed then, go to the next fix.
Fix 3: Try to update Excel on Mac
Follow the below given steps to Setup Microsoft AutoUpdate
Step 1: First you have to open any other Microsoft Office Application such as Word, Excel, PowerPoint, or Outlook.
Step 2: From the top menu, navigate to the Help > Check for Updates.
Step 3: Under the “How would you like updates to be installed?” option then select the Automatically Download and Install.
Step 4: At last, click on the Check for Updates.
Fix 4: Remove and then reinstall Office
Step 1: navigate through the Finder > Applications.
Step 2: Press the Command +click to choose all of the Office for Mac applications.
Step 3: Select the Microsoft office and press the Ctrl+click then click Move to Trash.
Visit: https://support.microsoft.com/help/2398768/ to remove Office for Mac 2011
Conclusion
That’s all about the Microsoft excel quit unexpectedly Mac issue, it is hoped that after applying the above given solutions now your Excel app is working normally.
If you are unable to apply the above given steps due to lack of knowledge OR any other reasons then you can go with a professional Microsoft Excel Error Repair Tool. This troubleshooting tool will help you to deal with the several excel errors.
This Excel Repair Tool is fully automatic, hence you don’t need any professional experience. Simply download, Install and Run this tool on your Mac and fix Microsoft Excel error within a few minutes.
[Please Note: This is to inform that the Mac software is discontinued]If you still have any query or doubt related to the Microsoft Excel then kindly contact us @ http://ask.repairmsexcel.com
Resources:
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
Manually finding external links or references in a spreadsheet is a cumbersome task. Microsoft does not have any inbuilt function that can find external references or links but still there do exist some workarounds to do this. And this is what I am going to share with you today.
Method 1: Finding external References by using the find function
Though this is not a foolproof method still it can reduce the manual effort drastically. The main logic behind this method is that excel always encloses external references in long brackets “[]”. So, if you find all the “[]” brackets, you can easily get the list of external references used.
- Open the excel sheet, for which you want to find the external references.
- After this press the “Ctrl+F” keys to open the ‘Find’ and replace the dialog box.
- In the find, textbox enter the string “[*]” (without quotes). This string means that resultant will be any string enclosed within long brackets.
- Next, in the ‘Look in’ dropdown select Formulas and hit the “Find All” button.
- The resultant will be a set of external references that are used in the sheet.
Method 2: Edit Links Option
On the excel ribbon there a ‘Data’ tab, inside this tab, there is an option called “Edit Links”.
Basically, the edit link option displays all the other files to which your spreadsheet is linked to. Please note that this option will be disabled by default and will only become active if your sheet contains some external references.
So, this can become a quick check to verify if your excel sheet contains external references or not. Using “Edit Links” is quite easy just follow the below steps to remove external references from your excel sheet:
- Open your excel sheet and navigate to the ‘Data’ tab, select the option “Edit Links”.
- In the “Edit Links” window all the spreadsheets which are referenced in your excel file will be listed.
- On the right side of this Edit Links window there are options like ‘Update values (can be used for reloading the values)’, ‘Change Source (can be used to change the referenced file)’, ‘Open Source (opens the referenced excel files)’ and ‘Break Links (can be used to break the referenced links)’.
- Among all these options ‘Break Links’ option is the one that we will be using, it breaks the references and replaces them with their current values.
- Please note that the use of this feature should be done with utmost care as this cannot be undone.
Broken Links In Excel File
Method 3: Find External Reference links by using Excel Macro
Getatpuiculturetag Excel Error Fix
Using excel macros can be really helpful in finding the external reference links. To create a macro that can find and list down all the external links in a spreadsheet, follow the below steps:
- With the excel sheet opened, navigate to the ‘View’ Tab, click on the ‘Macros’ button.
- Now enter the macro name say “Fetch_Links” (without quotes) and hit the create button.
- This will open the Excel VBA editor, simply paste the below code after the first line.
- The whole code should look the same as shown in the below screenshot.
- Now simply press the ‘F5’ button to run the macro. The code will create a new worksheet that contains all the external referenced links.
Method 4: Find and Delete Links Add-in
If you don’t want to use any of the first 3 methods then you should probably go for this one. Microsoft has now developed an Excel add-in that can run as a wizard and finds all the external links that your spreadsheet contains. It also has a feature to delete the referenced links.
Excel For Mac 2011 Fix Link Error Windows 10
You can find this add-in here.