Microsoft Excel Keeps Freezing On Mac
- Excel Freezing Up
- Mac Excel Keeps Crashing
- Microsoft Excel Keeps Freezing On Mac Pro
- Microsoft Excel Keeps Freezing On Mac And Cheese
This Excel tutorial explains how to freeze panes to keep the first column visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions). In Microsoft Excel 2011 for Mac, I have a spreadsheet and I need to freeze the first column. Mar 19, 2020 Question Info. Restart your Mac, then immediately press and hold the Shift key. The white Apple logo appears on your display. Release the shift key when you see the logo window. If your startup disk encrypted with FileVault, you might be asked to log in twice: once to. Run Excel again to see if.
- Jan 29, 2018 The COM add-ins fight over the memory and cause the Excel to freeze and crashing issue. So, the best is to disable the COM add-ins, follow the steps to do so: Choose File then go to Options and Add-ins. Then at the bottom of dialog box modify the Manage drop-down to COM add-ins choose Go.
- 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.
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
Excel Freezing Up
When you open or use Microsoft Excel, Excel stops responding, hangs, freezes, or stops working. Additionally, you may receive one of the following error messages:
Excel is not responding.
Microsoft for mac free download 2016. It is full Latest Version setup of Microsoft Word 2016 15.39 Premium Pro DMG for Apple Macbook OS X.Brief Overview of Microsoft Word 2016 for Mac OS XMicrosoft Word 2016 is a world renowned and most widely used word processing application included in the Office suite.
Excel has stopped working.
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.
Resolution
Use the following methods in the order in which they are presented. If you try one of these methods and it does not help, go to the next method.
Method 1: Start Excel in safe mode
Mac Excel Keeps Crashing
Safe mode lets you safely use Excel without encountering certain startup programs. You can open Excel in safe mode by pressing and holding Ctrl while you start the program or by using the '/safe' option (that is, excel.exe /safe) when you start the program from the command line. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, the xlstart folder, and Excel add-ins. (However, COM add-ins are excluded.)
If your issue is resolved after you run Excel in safe mode, see the following articles in the Microsoft Knowledge Base:
291288 Description of the startup switches for Excel
280504 How to troubleshoot startup problems in Excel 2013
If your issue is not resolved after you start Excel in safe mode, go to method 2.
Method 2: Investigate possible issues with COM add-ins Many developers create add-ins for Excel. These add-ins are divided into two types
- Excel add-ins that are saved as .xla, .xlam, or .xll files.
- COM add-ins. These add-ins usually have to be installed and include DLLs and registry keys. COM add-ins created for one version of Excel frequently are incompatible with a newer version, and may cause the system to stop responding. They are not disabled by safe mode.
The simplest way to resolve this possible cause is to run this troubleshooter.
If the troubleshooter resolves the issue, but it recurs, you'll have to determine which add-in is causing the problem. To disable COM add-ins, follow these steps:
- Select File > Options > Add-ins.
- At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go.
- Clear the check box for any enabled COM add-ins. select OK.If disabling the COM add-ins alleviates the issue, try enabling them one at a time to test for the problem add-in.
If these steps do not resolve your issue, continue to method 3.
Method 3: Investigate Excel file details and contents
Excel files can exist on the computer for a long time. They are upgraded from version to version and frequently travel from one user to another user. Frequently, a user inherits an Excel file but doesn't know what is included in the file. The following areas can cause performance or crashing issues:
- Formulas referencing entire columns.
- Array formulas referencing an uneven number of elements in the arguments.
- Hundreds, or perhaps thousands, of hidden or size 0 height and width objects.
- Too many styles caused by frequent copying and pasting between workbooks.
- Too many (as well as invalidly defined) names.
Inspect and simplify your files if possible.
If these steps do not resolve your issue, continue to method 4.
Method 4: Check whether your file is being generated by a third party
Sometimes Excel files are generated by a third-party application. In this case, the files may be generated incorrectly, and some features may not work correctly when you open the files in Excel. If this occurs, test the features in new files outside the third-party application. If the features work correctly, make sure that the third party is aware of the issue.
If your issue is not resolved after you test it outside the third-party application, go to method 5.
Method 5: Perform a selective startup to determine whether a program, process, or service conflicts with Excel
When you start Windows as usual, several applications and services start automatically and then run in the background. These applications and services can interfere with other software on your device. Performing a selective startup (also known as a 'clean boot') can help you identify problems with conflicting applications. To perform a selective startup, see How to perform a clean boot in Windows.
Selective startup is used to help identify the process, service, or application that conflicts with Excel.
Silverlight means Business. SAP is the world's largest business software company. For their Business ByDesign product, SAP utilized Silverlight's powerful.NET programming model and familiar Visual Studio tools to rapidly develop a visually compelling and easy to use application. 2020-4-3 The Official site of Microsoft Silverlight. Download and install the latest version Microsoft Silverlight plug in for your browser. 2013-1-21 Microsoft Silverlight IS a Plugin. If your iMac is an Intel iMac and running, at least OS X 10.5.7 then you can install this plugin. If you are running OS X 10.5.7 on an older PowerPC iMac, Silverlight cannot be downloaded and won't work. Microsoft silverlight on a mac. 2020-3-19 I contacted both Microsoft and Netflix to try and resolve the issue. I have a Macbook Pro. I used to be able to stream Netflix. How do you get Silverlight to work on a MacBook Pro. I'm stuck in a loop of installing, uninstalling, installing, uninstalling. Run the fix it and check.
If your issue is not resolved after a clean boot, go to method 6.
Method 6: Check whether your antivirus software is up to date or is conflicting with Excel
Antivirus software can interfere with Excel, and cause performance issues. Frequently updating your AV software can correct the issue.
How to check whether your antivirus software is up to date
To keep up with new viruses that are created, antivirus software vendors periodically provide updates that you can download from the Internet. Download the latest updates by visiting your antivirus software vendor's website. For a list of antivirus software vendors, see the following Microsoft website:
How to check whether antivirus software is conflicting with Excel
If your antivirus software includes integration with Excel, you may experience performance issues. In this case, you can disable all Excel integration within the antivirus software by creating exceptions for Excel files.
Important
Changing your antivirus settings may make your PC vulnerable to viral, fraudulent, or malicious attacks. We do not recommend that you try to change your antivirus settings. Use this workaround at your own risk. You may have to contact your antivirus software vendor to determine how to configure software to exclude any integration with Excel.
If updating your antivirus software or excluding it from integrating with Excel does not resolve your issue, go to method 7.Method 7: Verify or install the latest Windows and Office updates
Windows updates
You might have to set Windows Update to automatically download and install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities.To install the latest Windows updates, see Microsoft Windows FAQ.
Office updates
Microsoft Excel Keeps Freezing On Mac Pro
For more information about the latest Office updates, see Office Updates.
If your issue is not resolved after you install the latest Windows and Office updates, continue to the advanced troubleshooting in the More Information section.
More information
Advanced troubleshooting
If the methods that were mentioned earlier did not resolve your issue, the issue might be either environmental or file-specific in nature. The following section describes how to troubleshoot additional issues that can cause Excel to stop responding.
Environmental factors
Environmental factors are just as important as file contents and add-ins when you are troubleshooting problems. You can help us determine the cause of your issue by taking the following actions:
- Follow basic troubleshooting steps.
- Test files in the cleanest possible environment.
The following sections describe troubleshooting tips that might help diagnose the problem.
Where the file is stored
Several issues can arise when you save an Excel file over a network or to a web server.Moving the file locally will help determine whether there's something wrong with the file or the server where the file is saved. Save the file to your local hard drive is one of the following scenarios is true:
You have redirected 'My Documents' folder to a server location.
Your files are stored offline.
You are trying to open files from SharePoint or a Web folder.
You are using Remote Desktop or Citrix.
You are using network appliances.
You work in a virtualized environment. For more information about Microsoft software that's running in a virtualized environment, see the following Microsoft Knowledge Base article:
897615 Support policy for Microsoft software running in non-Microsoft hardware virtualization software
Memory
Excel files can grow fairly large when you add text formatting and shapes. Make sure that your system has enough RAM to run the application. For system requirements of the Microsoft Office suites, see the following Microsoft Knowledge Base article:
Printers and video drivers
When Excel is started, it examines the default printer and video drivers that will display the Excel workbooks. Excel is printer-intensive. Therefore, it will run even slower when Excel files are saved in Page Break Preview view. Testing the file by using different printers such as the Microsoft XPS Document Writer printer driver or the VGA video driver will determine whether the problem is with a specific printer or video driver.
If you still have hanging or crashing issues in Excel after you work through the resolution methods that are mentioned here, contact Microsoft Support for guided troubleshooting.
We all want our Macs to run fast and hate it if the machine keeps freezing (or completely frozen, sometimes). When that happens, frustration sets in.
In this article, we’re going to share some common Mac freezing scenarios, along with quick fixes.
For better reading experience, we break down the scenarios into five sections. Just navigate the Table of Content below to help yourself jump to the right section based on the scenario that fits your situation.
Why Does My Mac Keep Freezing?
A MacBook or iMac can freeze while running certain apps with a symptom being unresponsive. Other times, macOS may hang up while you surf the Internet via a web browser like Safari, Chrome, Firefox, etc.
There are quite a few possible causes out there. For example, your Mac may have too many login items auto launching upon start-up, or lots of background app clutter.
What to do? The easiest fixes are: reduce the number of login items, force quit those frozen applications, update your Mac to latest macOS (i.e. Catalina), etc.
Your Mac may also run slowly, hang up, or become totally frozen when the computer runs out of memory and it has to use the disk instead of RAM.
You can use iStats Menus to check real-time memory usage and other key performance metrics of your Mac. It’s also an app we recommend for diagnosing Mac issues.
Read on for how to unfreeze your Mac under different scenarios.
1. Your Mac Freezes Randomly
If your Mac freezes from time to time even if it’s not running any third-party apps at all, or you feel there’s always a delay in responding on certain requests, it’s possible your Mac startup disk is almost full. Another reason could be System Management Controller (SMC) needs to reset, as Apple says:
“These symptoms might mean that an SMC reset is necessary: … your Mac performs unusually slowly, even though its CPU isn’t under an abnormally heavy load.”
How to fix: clean up disk drive, reset SMC
The best way to clean up Mac drive is to use CleanMyMac, an incredibly simple and intelligent app that can help you detect all type of system junk and unnecessary files. By doing so, you can quickly free up gigabytes of disk space.
As for resetting SMC, just follow the step-by-step instructions from this Apple guide.
2. Mac Freezes When Open Certain Apps
It’s quite common that Mac freezes on certain apps, especially those poorly developed ones which require substantial system resources than they should.
macOS usually indicates the situation by popping up a notification Application Not Responding. This happens more often while you are using heavy apps like image or video editing software that demands more system resources than other light-weighted apps.
How to fix: force quit, and keep the app up to date
The first yet no-brainer solution is: keep waiting until the app unfreezes by itself. If it’s still unresponsive after a few minutes, try force quit the application. To do this, move your cursor to the application icon on the dock (normally located at the bottom of your screen). Then right click on the app icon. Wait until a pop-up menu displays. macOS will then present the option for you to “Quite.”
Alternatively, you can click on the Apple logo, select Force Quit, then highlight the app you want to exit, and hit the blue “Force Quit” button.
Next, check whether the app has a newer version. For example, if you are using Photoshop, go to Adobe’s official website to see if the version you’re using is the latest. Those of you who are used to download programs from the Mac App Store, you can also go to Software Update to check if there’s a new update.
Always keep your apps up-to-update because a newer version usually fixes bugs and errors that could eliminate app frozen times.
3. Web Browser Keeps Freezing on Mac
According to Apple Support Community threads, some users have been experiencing difficulties with Safari after updating their Macs to the latest macOS, such as web browser crashes or keeps freezing.
How to fix: first remove the third-party extensions you recently installed. Because those plug-ins/extensions might be incompatible with the web browser you use. Open Safari, on the top click Safari Menu, select Preferences. Under the Extensions tab, select and uninstall the ones you recently installed.
If that doesn’t solve the problem, you’ll need to reset Safari. It’s also quite simple. This video tutorial shows how:
If the web browser continues to freeze, we’d recommend a full macOS check-up and update. Make sure to back up your data before you do this. Updating macOS is a fairly simple process. Simply click on the Apple logo, then App Store option, you’ll see the number of updates available.
Once updated, it should fix the browser keeps freezing issues and prevent your Mac from other issues in the future.
4. Mac Keeps Freezing on Startup
If your Mac often freezes upon startup, chances are you have excessive login items or launch agents. Those are applications, services, or server connections that run automatically when your Mac starts.
Another possible cause is the Non-Volatile Random-Access Memory (NVRAM) issue, as Apple puts in this article:
“…if your Mac starts up from a disk other than the one selected in Startup Disk preferences, or a question mark icon briefly appears before your Mac starts up, you might need to reset NVRAM.”
How to fix: optimize login items and reset NVRAM
Disabling unnecessary startup items is simple, just do a Spotlight search for “Users & Groups” (alternatively, click on the Apple icon, then System Preferences, click on Users & Groups). See the Login Items tab next to Password? Here you’ll find a list of applications and auto-start programs, feel free to remove those you rarely use.
Note: there may be some launch agents that do not show under Login Items, but they still run on startup. You can disable or remove them in CleanMyMac (via Extensions > Launch Agents, as shown below).
Resetting NVRAM is easy and risk-free. Simply shut down your Mac and press the four combination keys as shown in this video guide.
5. Mac Is Frozen Completely
If the entire system of your Mac frozen and you can’t even move the cursor around. Your last option is to force reboot the Mac manually.
If you are on a MacBook Pro or MacBook Air, hold down the Power button (located on the keyboard for newer MacBooks) for 5 seconds or so, until the system shuts down completely. Then press it again to start.
If you are on an iMac or Mac Mini, the Power button is on the back of the monitor. Similarly, press it for a few seconds and release it when your Mac shuts down.
Final Words
It’s annoying to see Mac keeps freezing or frozen to death, and that happens from time to time. Reasons vary from case to case, while the common one is Mac uses up the RAM memory and has to opt for disk memory. But there are things you can do to fix the issue, though it depends on what kind of “freeze” you’re facing.
One more thing: don’t forget to back up your Mac data on a regular basis. Because when your Mac is totally frozen you’ll have to force quit apps or reboot, during the process you may lose some files due to not being saved in time. A backup is the best protection plan for data disasters.
Have you managed to fix the Mac freezing issue? Or you happen to discover a new solution? Leave a comment and let us know.
Microsoft Excel Keeps Freezing On Mac And Cheese
Andreas is a freelance tech writer based in California. He works on a Mac in the office and lives with a PC and many old computer electronics at home. While he is not reading or writing, you’ll probably find him playing online games with friends.