Microsoft Excel For Mac Keeps Freezing

-->

Excel is the most powerful tool for analyzing large sets of data. However, to keep your headers on screen, you need to learn how to freeze a row in excel on mac.That way, you won’t lose sight of valuable data on your top row or column when scrolling your spreadsheet. Microsoft Excel is a powerful program. So powerful, that it’s probably the most susceptible to have problems. I have troubleshot problems with Excel freezing and saying “Not Responding” in Windows. The reasons this happen can vary greatly. Here are the most common ways to fix the problem.

Excel freezing up

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

When you save a Word for Mac document, the application crashes or quits unexpectedly.

Resolution

Step 1: Download and install all Office updates

To obtain updates with Office for Mac applications, follow these steps:

Microsoft AutoUpdate for Mac, which comes with Office, can keep your Microsoft software up to date. When AutoUpdate is set to check for updates automatically on a daily, weekly, or monthly basis, there's no need to search for critical updates and information; AutoUpdate delivers them directly to your computer. To do this:

Undertaking the Microsoft Office 2016 Mac review, critics made exceptionally favorable comments. Microsoft Office 2016 For Mac Free Download Full Version What?s New in Microsoft Office 2016 for Mac?In the Mac release, the update introduces a modest number of new features that include an update, intuitive?user interface?that uses?ribbons, comprehensive support for?Retina Display, and new sharing features for a set of Office documents.Microsoft Office 2016 Mac free comes with a new Design tab in Word, an Insights feature? Download NowMicrosoft Office 2016 For Mac Free Download Full Version in a single fast link. It was released on July 9, 2015 on?mac-OS. Microsoft office for mac yosemite free. It is an offline installer of complete MS Office 2016 for Mac OS Microsoft Office 2016 OverviewThe tech company has released Office 2016?s three traditional editions for Mac that include Home & Student, Home & Business, and StandardMicrosoft Office 2016?is the latest entry in the?Microsoft Office?productivity suite, successor of both?Office 2013?and?Office 2011 for Mac.

  1. Start any Office for Mac application on your computer.
  2. Click Help menu, click Check for Updates.

For additional information about Office for Mac updates, seeWhere and how to obtain Office for Mac software updates.

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

Step 2: Check the hard disc name

Make sure that your hard disc has a name. The name cannot be all numbers but can contain numbers. The name must start with a letter. It must not contain any special characters, such as periods, commas, semi-colons, quotation marks, and so on.

Step 3: Save to a different location

If you are saving a file in your Documents folder, instead try saving the file to the desktop or to a different location.

Remember that there is a 255-character limit to the file name, and the path of the saved file is included in the name. For example, a file that is saved to the desktop has the path 'HDusersyour user nameDesktop.' These characters are counted toward the 255-character limit.

If you want to save to a network share or to an external device (such as a flash drive), first save the file to your local hard disc. If you can save the file to the hard disc (your Documents folder), there is nothing wrong with the Excel installation or with the file. If you cannot save to your local hard disc, go to step 3.

If you cannot save the file to an external device, contact Apple or the manufacturer of the external device. If you cannot save to a network share, contact the network administrator (your IT department) or the owner of the share. If you do not have an IT department and you want to save to a network, contact Microsoft Professional Support.

Step 4: Empty the AutoRecovery folder

Important

The location of certain files are different if you have Service Pack 2 (SP2) installed. To check if it is installed, open Word, and then click About Word from the Word menu. If the version number is 14.2.0 or above, you have Service Pack 2 and you should follow the Service Pack 2 steps when provided in this article.

If there are too many items in the AutoRecovery folder (userDocumentsMicrosoft User DataOffice 2008 AutoRecovery or Office 2010 AutoRecovery), this can cause memory problems and save problems because these files are loaded into memory when Word is started.

Move AutoRecovery files to the desktop or to another folder to see whether they are causing the problem. To do this, follow these steps:

Microsoft Excel For Mac Keeps Freezing 2

To empty the AutoRecovery folder, follow these steps if have version 14.2.0 (also known as Service Pack 2) installed:

  1. Quit all applications.

  2. On the File menu, click New Folder.

    A new folder is created on the desktop. The folder will be called 'New Folder.'

  3. On the Go menu, click Home.

  4. 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.

  5. Open Application Support, and then open Microsoft.

  6. Open Office 2011 AutoRecovery.

  7. On the Edit menu, click Select All.

  8. Drag all files into 'New Folder' on the desktop.

    The AutoRecovery folder should be empty.

  9. Open Excel for Mac 2011 and try to save a file.

    If you can save a file, review the contents of 'New Folder' to decide which files that you want to keep.

    If the problem continues to occur, go to the next method.

To empty the AutoRecovery folder, follow these steps if you do not have Service Pack 2 installed:

Excel Keeps Freezing Up

  1. Quit all applications.

  2. On the File menu, click New Folder.

    A new folder is created on the desktop. The folder will be called 'New Folder.'

  3. On the Go menu, click Documents.

  4. Open Microsoft User Data, and then open Office 2011 AutoRecovery.

  5. On the Edit menu, click Select All.

  6. Drag all files into 'New Folder' on the desktop.

    The AutoRecovery folder should be empty.

  7. Open Excel for Mac 2011 and try to save a file.

    If you can save a file, review the contents of 'New Folder' to decide which files that you want to keep.

    If the problem continues to occur, go to the next method.

Step 5: Remove Word preferences

Note

Removing the preferences will remove any customizations that you made. These customizations include changes to toolbars and custom dictionaries and keyboard shortcuts that you created.

  1. Quit all Microsoft Office for Mac applications.

  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 Preferences.

  5. Look for a file that is named com.microsoft.Word.plist.

  6. If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.

  7. If you locate the file and move it to the desktop, start Word, and check whether the problem still occurs. If the problem still occurs, quit Word, and then 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.Word.plist file to the trash.

  8. Quit all Office for Mac applications.

  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 Preferences, and then open Microsoft.

  12. Locate the file that is named com.microsoft.Word.prefs.plist.

    It allows users to choose among great-looking resumes and newsletters, complex photo catalogs, and calendar layouts, which let you fill in your information without the need for extra formatting. With the help of MS Words, users can create any type of document with other powerful tools such as the watermark, font size, font style, and table. Microsoft office 2010 torrent with key. MS PowerPoint allows users to create the stunning presentation with many animation effects. MS Excel helps users to create spreadsheets and manage other records in easiest way.Office 2011 for Mac features an enormous number of templates in the Template Galleries for Word, PowerPoint, and Excel.

  13. Move the file to the desktop.

  14. Start Word, and then check whether the problem still occurs. If the problem still occurs, quit Word, 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.Word.prefs.plist file to the trash.

  15. On the Go menu, click Home.

  16. 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.

  17. Open Application Support, and then open Microsoft.

  18. Open Office, and then open User Templates.

  19. Locate the file that is named Normal, and then move the file to the desktop.

  20. Start Word, and then check whether the problem still occurs. If the problem seems to be resolved, you can move the Normal file to the Trash. If the issue continues to occur, go to the next step.

Mac Excel Keeps Freezing

Step 6: Create a new user account

Sometimes, user-specific information can become corrupted. This can interfere with installing or using the application. To determine whether this is the case, you can log on as a different user or create a new user account, and then test the application.

If the issue occurs even when you use the alternative account, go to the next step.

Step 7: Test saving the file in safe mode

Try to save when the computer is operating in safe mode. If you can save while in safe mode, the problem probably concerns software that is running in the background.

For information about how to enter safe mode in Mac OS, seeClean startup to see if background programs are interfering with Office for Mac.

Excel Keeps Freezing

More information

Microsoft Excel For Mac Keeps Freezing Windows 7

If the steps in this article did not resolve the issue, visit the Mac forums for possible resolutions/workarounds.