DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 975724 - Last Review: January 5, 2012 - Revision: 13.0

On This Page

SYMPTOMS

When you start Microsoft Excel for Mac or when you try to open a new Excel workbook, you experience one of the following conditions: 
  • The program closes unexpectedly.
  • You receive an error message: 
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 

RESOLUTION

To resolve this problem, follow methods listed below for your version of Office.

Excel 2008 or later

Step 1: Quit all programs and close all windows


 1. On the Apple menu, click Force Quit.

 2. Select an application in the "Force Quit Applications" window.
Note You cannot quit Finder.

 3. Click Force Quit.

Collapse this imageExpand this image



 4. Repeat the previous steps until you quit all active applications.


Step 2: Remove Excel Preferences
  1. Quit all Microsoft Office for Mac programs. 
  2. On the Go menu, click Home
  3. 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. 
  4. Open the Preferences folder. Click View , click Arrange by then Name. 
  5. Look for a file that is named com.microsoft.Excel.plist. 
  6. If you locate the file, click and then drag and drop the file to the Desktop. If you do not locate the file, the program is using the default preferences.  
  7. 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 Microsoft 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. 
  8. Quit all Microsoft Office for Mac programs. 
  9. On the Go menu, click Home
  10. 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. 
  11. Open the Preferences folder. 
  12. Open the Microsoft Folder. 
  13. Look for a file that is named com.microsoft.Excel.prefs.plist.
  14. If you locate the file, move it to the Desktop. If you do not locate the file, the program is using the default preferences. 
  15. 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 Microsoft 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. 
  16. Close all Microsoft Office applications. 
  17. On the Go menu, click Home
  18. 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. 
  19. Open the Preferences folder. 
  20. Open the Microsoft Folder. 
  21. Open the Office 2008 or Office 2011 folder. 
  22. Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars
  23. If you locate the file, move it to the desktop. If you do not locate the file, the program is using the default preferences. 
  24. If you locate the file and move it to the desktop, start Microsoft Excel, and check whether the problem still occurs. If the problem still occurs, quit Microsoft 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 toolbars file to the trash. 

If the problem continues to occur, proceed to the next step.

Step 3: Peform clean boot 

For information how to clean start your Operating system (OS), see Microsoft Knowledge Base article:

2398596 (http://support.microsoft.com/kb/2398596/)  Perform a clean startup (Safe mode) to determine whether background programs are interfering with Office for Mac

If the problem continues to occur, proceed to the next step.

Step 4: Remove and then reinstall Office 

For information how to remove and then reinstall Office, see Microsoft Knowledge Base article:

2500821 (http://support.microsoft.com/kb/2500821) Manually remove Office 2008 for Mac completely from your computer

2398768 (http://support.microsoft.com/kb/2398768/) How to completely remove Office for Mac 2011

If the issue continues to occur in Safe mode, proceed to Step 3. 

Step 5: Use the "Repair Disk Permissions" option 

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:

  1. On the Go menu, click Utilities
  2. Start the Disk Utility program. 
  3. Click the primary hard disk drive for your computer. 
  4. Click the First Aid tab. 
  5. 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. For more information about the Repair Disk Permissions option, see the following AppleCare article: http://docs.info.apple.com/article.html?artnum=10671 (http://docs.info.apple.com/article.html?artnum=106712)


Microsoft Excel 2004 for Mac

  1. Quit all Microsoft Office for Mac programs.
  2. On the Go menu, click Home.
  3. 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.
  4. Open the Preferences folder.
  5. Look for a file that is named com.microsoft.Excel.plist.
  6. If you locate the file, move it to the desktop. If you do not locate the file, the program is using the default preferences.
  7. 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.
  8. Quit all Microsoft Office for Mac programs.
  9. On the Go menu, click Home.
  10. 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.
  11. Open the Preferences folder.
  12. Open the Microsoft Folder.
  13. Look for a file that is named com.microsoft.Excel.prefs.plist.
  14. If you locate the file, move it to the desktop. If you do not locate the file, the program is using the default preferences.
  15. 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.prefs.plist file to the trash.
  16. Close all Microsoft Office applications.
  17. On the Go menu, click Home.
  18. 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.
  19. Open the Preferences folder.
  20. Open the Microsoft Folder.
  21. Look for a file that is named Excel Toolbars (11).
  22. If you locate the file, move it to the desktop. If you do not locate the file, the program is using the default preferences.
  23. 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 Excel Toolbars (11) file to the trash.
  24. Start Excel, and check whether the problem still occurs.
If the problem still occurs, 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, you have to restore the files to their original location one at a time. Test the program after you restore each file. Continue to do this until the program occurs again. When the problem, the problem is related to the last file that you restored. Delete that file by dragging it to the trash.

APPLIES TO
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel 2008 for Mac
  • Microsoft Excel for Mac 2011
Keywords: 
kbsurveynew kbprb dftsdahomeportal KB975724
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support