- The Selected property of the listbox on the Mac appears to be broken, so it seems useless cross platform. If you looking to iterate through to work out which items are selected using (for example): For i = 1 To.ListCount - 1 If.Selected(i) Then Action here End If Next i. The method works on Excel 2010 but seems not be supported in Excel 2011.
- Make sure that the Microsoft Office 2011 folder is located in the Applications folder on the startup volume. If it is at another location on your computer, move it to the Applications folder on your startup volume, and then try installing the update again. Restart your computer and try installing the update again.
Learn the basics of using Microsoft Excel for Mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. Photo viewer for mac free download. For more information about this change, read this blog post.
Symptoms
When you try to start Microsoft Excel for Mac, you receive the following error message:
Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
Cause
This error may occur if one of the following conditions is true:
- The Excel preferences are corrupted.
- Programs that are running in the background are interfering with Excel for Mac.
- Application files are corrupted.
- A user account profile is corrupted.
Resolution
To resolve this issue, try the following methods, in order, until the issue is resolved.
Method 1
Step 1: Quit all programs
You must quit all programs before you continue. To quit an application, select the application on the toolbar (top), and then select Quit. If you cannot quit an application or do not know how, hold down the Command and Option keys, and then press Esc on your keyboard. Select the application in the 'Force Quit Application' window, and then select Force Quit. Click Force Quit to quit the application.
When you are finished, click the red button in the upper-left corner and go to step 2.
Step 2: Remove your Excel preferences
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 Preferences.
Drag com.microsoft.Excel.plist to the desktop. If you cannot locate the file, Excel is using the default preferences. Go to step 7.
Open Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, restore the file to its original location, and go to the next step. If the problem is resolved, drag com.microsoft.Excel.plist 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 Preferences.
Open Microsoft, and then drag com.microsoft.Excel.prefs.plist to the desktop. If you cannot locate the file, Excel is using the default preferences. Go to step 13.
Open Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, restore the file to its original location, and go to Method 2. If the problem is resolved, drag com.microsoft.Excel,prefs.plist to the Trash.
Method 2
Use the 'Repair Disk Permissions' option Processor for mac os.
You can use the Repair Disk Permissions option to troubleshoot permissions problems in Mac OS X 10.2 or later versions. To use the Repair Disk Permissions option, follow these steps:
- On the Go menu, click Utilities.
- Start the Disk Utility program.
- Click the primary hard disk drive for your computer.
- Click the First Aid tab.
- Click Repair Disk Permissions.
Note
The Disk Utility program only repairs software that is installed by Apple. This utility also repairs folders, such as the Applications folder. However, this utility does not repair software that is in your home folder.
Open Excel and check if the issue is resolved. If it is not, continue to Method 3.
Method 3
Create and use a new user account
To create a new user account, use the following procedure.
Note
You many have to reinstall Office if you log on with a new account.
Click the Apple icon, and then click System Preferences.
Click Accounts.
Click the plus sign ('+') in the lower-left corner to open the new account window.
Note
If you are not the Administrator of the computer, click Click the lock to make changes. Log on by using your Administrator user name and password, and then click OK.
Type the word Test for the user name, and leave the password box blank. Click Create Account. When you receive a warning, click OK.
Click to select Allow User to Administer this computer. (If this option is not available, just go to the next step).
Click the Apple icon, and then click Log Out name.
Log on with your Test account.
Open Excel and check if the issue is resolved. If you can save when you use a new user account, contact Apple support to troubleshoot your existing account. If you do not want to keep your existing account, you can rename the 'Test' account that you create in the following procedure, and continue to use that account. If it is not, continue to Method 4.
Method 4
Remove and then reinstall Office
For information about how to remove and then reinstall Office, see the following article:
Third-party disclaimer information
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
The information and the solution in this document represent the current view of Microsoft Corporation on these issues as of the date of publication. This solution is available through Microsoft or through a third-party provider. Microsoft does not specifically recommend any third-party provider or third-party solution that this article might describe. There might also be other third-party providers or third-party solutions that this article does not describe. Because Microsoft must respond to changing market conditions, this information should not be interpreted to be a commitment by Microsoft. Microsoft cannot guarantee or endorse the accuracy of any information or of any solution that is presented by Microsoft or by any mentioned third-party provider.
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.
Microsoft Excel For Mac 2011
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.
Excel For Mac 2011 Fix Link Error Key
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.
