Microsoft Excel是(Microsoft Excel)Microsoft Office套件的一部分，是许多专业人士的必备工具。不幸的是，Excel崩溃可能会带来很大的不便，从而导致潜在的数据丢失和工作流程中断。
如果您发现Excel不断崩溃或Excel无响应，请放心，这款流行的办公应用程序有办法解决这些问题！
为什么 Excel 会崩溃？
Microsoft Excel在 Windows 10 或 11 计算机上崩溃的原因有多种。例如，您可能正在处理损坏的Excel文件或可能遇到(Excel)Excel加载项问题。即使是一些看似无关的问题，例如Microsoft Excel动画问题或过时的(Microsoft Excel)MS Office版本，也可能引发崩溃。
Excel也可能由于数据过多或条件格式规则复杂而冻结。请记住(Remember)，Excel是一个强大的工具，但它也有局限性。尝试处理过多的数据或应用复杂的规则可能会导致数据在压力下崩溃。
另外，不要忽视操作系统或防病毒软件出现问题的可能性。有时，这些可能会干扰Excel并导致其行为异常。
解决Excel崩溃问题并不总是一项简单的任务。它需要一个系统的方法来识别根本原因，然后解决它。但是，只要有耐心并掌握一些技术知识，您就可以立即使Excel恢复正常。
1.更新Excel
解决Excel(Excel)崩溃问题的首要步骤之一是检查您是否有Microsoft Excel和操作系统的最新更新。对于MS Office，您可以单击File > Account > Update Options。
选择立即更新(Update)以检查是否有任何可用更新。更新完成后，您必须重新启动Excel，因此在尝试更新之前请确保没有任何未保存的工作。
2.以安全模式打开Excel
在安全模式下运行Excel可以帮助确定崩溃问题是否是由任何加载项或启动选项引起的。该模式试图通过仅加载核心程序来保证Excel的功能，而不加载任何第三方插件。
要在安全模式下打开Excel ，请在启动Excel时按住Ctrl键。如果问题消失，则可能是由于加载项或启动选项所致。在撰写本文时， Mac(Mac)版本的Excel似乎没有安全模式(Mode)选项。
3.禁用加载项
如果您怀疑Excel加载项可能导致Excel崩溃，您可以单独禁用它们以查找罪魁祸首。
选择“插入”选项卡(Insert Tab)，然后选择“我的加载项”(My Add-ins)。
在加载项旁边，选择其三点按钮，然后选择“删除”(Remove)。
4.禁用硬件图形加速(Hardware Graphics Acceleration)
Microsoft Excel使用硬件图形加速来加速图形的显示。但是，此功能可能会导致问题。
要禁用硬件图形加速，请转到File > Options > Advanced，然后在“显示”下，选中(Display)“禁用(Disable)硬件图形加速”框。
这可能会影响Excel 的(Excel)快速使用体验，如果更新操作系统或Excel后问题仍未消失，请考虑检查GPU驱动程序更新。
5.使用Excel的内置修复工具(Built-In Repair Tool)
如果您的Excel文件损坏，Excel的内置文件修复工具可以修复它。要使用此功能，请打开Excel，单击File > Open，然后浏览(Browse)到工作簿的位置。
选择损坏的Excel文件，然后单击(Excel)“打开”(Open)旁边的下拉箭头，然后选择“打开(Open)并修复”(Repair)。
6.重新安装Microsoft Office
如果上述解决方案均无效，您可能需要卸载并重新安装MS Office。您可以通过在“开始”菜单(Start Menu)中搜索“添加或删除程序” ，从已安装的应用程序列表中选择MS Excel或MS Office ，然后将其卸载来执行此操作。(MS Office)然后从Microsoft(Microsoft)网站运行 Web 安装程序。
如果您使用的是Mac，只需从“应用程序”文件夹中删除Excel或Office，然后使用从Microsoft站点下载的安装程序即可。
在这两种情况下，您都需要登录Microsoft帐户才能访问安装程序下载链接。确保(Make)为您的操作系统下载正确的安装程序。
7. 运行干净启动
干净启动可以帮助确定是否有任何第三方服务导致Excel崩溃。干净启动与安全模式(Safe Mode)不同，它仅禁用第三方启动程序，而安全模式(Safe Mode)不会加载任何不是绝对必要的内容。
有关干净启动及其操作方法的更多信息，请参阅如何在 Windows 10 中执行干净启动(How to Perform a Clean Boot in Windows 10)。
8. 检查恶意软件
恶意软件(Malware)是许多软件故障的常见罪魁祸首，Excel也不例外。这些恶意程序可能会干扰Excel的正常运行，导致其崩溃或冻结。因此，针对这些潜在威胁保持强大的防线至关重要。
首先确保您的防病毒软件是最新的。防病毒(Antivirus)提供商经常发布更新，以使其软件免受最新威胁，因此不要忽视这些更新，这一点很重要。确认您的防病毒软件是最新的后，请在您的计算机上运行全面扫描。此过程将识别并消除可能导致Excel崩溃的任何恶意软件。
某些防病毒软件有时会标记并阻止合法应用程序，将其误认为是威胁。如果您发现Excel在防病毒更新或扫描后立即崩溃，您可能需要调整防病毒设置以将Excel从其雷达中排除。
9.定期保存和备份你的(Backup)工作(Work)
请记住(Remember)定期保存您的工作，以防止因Excel意外崩溃而导致数据丢失。在进行任何重大数据输入或格式更改后保存Excel工作簿。另外，请考虑使用 Microsoft 的OneDrive自动保存Excel文件。这不仅有助于在崩溃时恢复数据，还使您能够从任何地方访问文件。
10.检查格式问题
过度使用复杂格式，尤其是条件格式，有时会导致Excel无响应。
如果您想了解有关Excel中的条件格式的更多信息，请转到使用 Excel 中的条件格式设置单元格格式(Format Cells using Conditional Formatting in Excel)。
11.检查任务管理器
如果Excel冻结，任务管理器(Task Manager)可以成为识别和解决问题的强大诊断工具。使用方法如下：
- Press Ctrl + Shift + Esc。该快捷方式将直接打开任务管理器(Task Manager)窗口。
- 在任务管理器(Task Manager)中，您将看到计算机上所有正在运行的应用程序的列表。浏览(Browse)此列表并找到Microsoft Excel。它应该被称为 excel.exe 或Microsoft Excel。
- 检查Excel(Excel)旁边的状态。如果显示 Not Responding，则Excel确实存在问题。
- 要解决此问题，请单击列表中的Microsoft Excel ，然后单击“结束(Microsoft Excel)任务”(Task)按钮。此操作将强制关闭Excel。
- 现在，您可以再次启动 Excel。
虽然此方法可以快速修复冻结的Excel（如果您发现自己经常使用任务管理器）(Task Manager)，但它可能表明该软件存在需要解决的更深层次的基本问题。
12. 执行系统文件检查
如果崩溃问题仍然存在，则操作系统文件可能存在问题。在Windows中，有几种方法可以快速检查系统文件是否已损坏或损坏。我们主要建议使用SFC（系统文件检查器(System File Checker)）或DISM（部署映像服务(Deployment Image Servicing)和管理(Management)）。
请参阅高级 Windows 系统清理命令 - SFC 和 DISM，(Advanced Windows System Cleanup Commands – SFC and DISM)了解有关如何使用这些工具的更多信息。
13.检查兼容性
如果您将旧版本的Excel(Excel)文件（如 .xls）与新版本的Excel一起使用，兼容性问题可能会导致Excel崩溃。在使用可能会触发崩溃的文件之前，请将其转换为Excel(Excel)副本支持的最新版本的文件。
14.联系微软支持
解决Excel崩溃问题通常看起来很有挑战性，尤其是当您正在进行重要工作时。不过，希望此处列出的解决方案能够帮助您解决Microsoft Excel崩溃或冻结的大多数问题。
如果您仍然无法解决问题，可能是时候联系最初创建Excel和MS Office的人了。(MS Office)转到 Microsoft 的“联系我们”(Contact Us)页面，选择Microsoft 365作为您需要帮助的产品，然后按照那里的说明进行操作。
Why Microsoft Excel Keeps Crashing on Your Computer (And 14 Fixes to Try)
Microsoft Excel, part оf the Micrоsoft Office suite, is an essential tоol for many professionalѕ. Unfortunately, Excel crashes сan cause substantial inconvenience, leading to potential data loss and disruptions in your workflow.
If you find that Excel keeps crashing or Excel is not responding, rest assured there are ways to address these issues with this popular office application!
Why Does Excel Crash?
There are a variety of reasons why Microsoft Excel might crash on your Windows 10 or 11 computer. For instance, you could be dealing with corrupt Excel files or perhaps encountering issues with Excel add-ins. Even something seemingly unrelated, like problems with Microsoft Excel animation or an outdated version of MS Office, can trigger a crash.
It’s also possible that Excel is freezing due to excessive data or complex conditional formatting rules. Remember, Excel is a powerful tool, but it has limitations. Trying to crunch too much data or apply intricate rules can cause it to buckle under pressure.
Also, don’t overlook the possibility of issues with your operating system or antivirus software. Sometimes these can interfere with Excel and cause it to behave erratically.
Troubleshooting Excel crashes isn’t always a straightforward task. It requires a systematic approach to identify the root cause and then resolve it. However, with patience and some technical know-how, you can get your Excel back on track in no time.
1. Update Excel
One of the first steps in troubleshooting an Excel crashing issue is to check whether you have the latest updates for Microsoft Excel and your operating system. For MS Office, you can click on File > Account > Update Options.
Select Update Now to check for any available updates. After the updates are complete, you will have to restart Excel, so make sure you don’t have any unsaved work before you attempt an update.
2. Open Excel in Safe Mode
Running Excel in safe mode can help identify if the crashing problem is due to any add-ins or startup options. This mode tries to ensure Excel’s functionality by only loading the core program, without any third-party addons.
To open Excel in safe mode, press and hold the Ctrl key while launching Excel. If the problem disappears, then it’s likely due to an add-in or startup option. At the time of writing it does not seem as if there’s a Safe Mode option for the Mac version of Excel.
3. Disable Add-ins
If you suspect that Excel add-ins might be causing Excel to crash, you can disable them individually to find the culprit.
Select the Insert Tab and then My Add-ins.
Next to the add-in, select its three-dot button and then Remove.
4. Disable Hardware Graphics Acceleration
Microsoft Excel uses hardware graphics acceleration to speed up the display of graphics. However, this feature can cause problems.
To disable hardware graphics acceleration, go to File > Options > Advanced, and under Display, check the box for Disable hardware graphics acceleration.
This might impact how snappy Excel feels to use, and if the problem doesn’t go away after updating your operating system or Excel, consider checking for GPU driver updates.
5. Use Excel’s Built-In Repair Tool
If your Excel file is corrupted, Excel’s built-in file repair tool can fix it. To use this feature, open Excel, click on File > Open and then Browse to the location of the workbook.
Select the corrupt Excel file, then click on the drop-down arrow next to Open, and select Open and Repair.
6. Reinstall Microsoft Office
If none of the above solutions work, you might need to uninstall and reinstall MS Office. You can do this by searching for “Add or remove programs” in the Start Menu, selecting MS Excel or MS Office from the list of installed applications, and uninstalling it. Then run the web installer from the Microsoft website.
If you’re on a Mac, simply delete Excel or Office from your Applications folder and then use the downloaded installer from the Microsoft site.
In both cases, you need to be logged into your Microsoft account to access the installer download link. Make sure to download the correct installer for your operating system.
7. Run a Clean Boot
A clean boot can help identify if any third-party services are causing Excel to crash. A clean boot is different from Safe Mode in that it only disables third-party startup programs, whereas Safe Mode doesn’t load anything that isn’t absolutely necessary.
For more information on clean booting and how to do it, head over to How to Perform a Clean Boot in Windows 10.
8. Check for Malware
Malware is a common culprit behind many software glitches, and Excel is no exception. These malicious programs can interfere with Excel’s normal functioning, causing it to crash or freeze. As such, it’s crucial to maintain a robust line of defense against these potential threats.
Start by ensuring your antivirus software is up-to-date. Antivirus providers frequently release updates to arm their software against the latest threats, so it’s important not to overlook these updates. Once you’ve confirmed your antivirus software is current, run a comprehensive scan on your computer. This process will identify and neutralize any malware that may be causing Excel to crash.
Some antivirus software can occasionally flag and block legitimate applications, mistaking them for threats. If you notice Excel crashing immediately after an antivirus update or scan, you might need to adjust your antivirus settings to exclude Excel from its radar.
9. Save Your Work Regularly and Backup
Remember to save your work regularly to prevent data loss due to unexpected Excel crashes. Save your Excel workbook after any significant data entry or formatting changes. Also, consider using Microsoft’s OneDrive to auto-save your Excel files. This not only helps with data recovery in case of crashes but also enables you to access your files from anywhere.
10. Check for Formatting Issues
Excessive use of complex formatting, especially conditional formatting, can sometimes lead to Excel not responding.
If you want to know more about conditional formatting in Excel, head over to Format Cells using Conditional Formatting in Excel.
11. Check Task Manager
If Excel freezes, the Task Manager can be a powerful diagnostic tool to identify and resolve the issue. Here’s how you can use it:
- Press Ctrl + Shift + Esc simultaneously. This shortcut will directly open the Task Manager window.
- In the Task Manager, you’ll see a list of all running applications on your computer. Browse through this list and locate Microsoft Excel. It should be called excel.exe or Microsoft Excel.
- Check the status next to Excel. If it says Not Responding, then Excel is indeed the problem.
- To resolve this, click on Microsoft Excel in the list and then click on the End Task button. This action will forcibly close Excel.
- Now, you can launch Excel again.
While this method can provide a quick fix to a frozen Excel if you find yourself frequently resorting to the Task Manager, it might indicate a deeper fundamental issue with the software that needs to be addressed.
12. Perform a System File Check
If the crashing issue persists, there might be issues with the operating system files. In Windows, there are a few ways to quickly check if any system files have become corrupt or damaged. Mainly we’d recommend using either SFC (System File Checker) or DISM (Deployment Image Servicing and Management).
Head over to Advanced Windows System Cleanup Commands – SFC and DISM for more information on how to use these tools.
13. Check Compatibility
If you are using an older version of an Excel file (like .xls) with a newer version of Excel, compatibility issues might cause Excel to crash. Before working with the file, potentially triggering the crash, convert it to the most current version of the file that your copy of Excel supports.
14. Hit Up Microsoft Support
Addressing Excel crashes can often seem challenging, especially when you’re in the middle of important work. However, hopefully, the solutions listed here should help you resolve most issues with Microsoft Excel crashing or freezing.
If you still can’t solve the problem, it might be time to reach out to the very people who created Excel and MS Office in the first place. Head over to Microsoft’s Contact Us page, and choose Microsoft 365 as the product you need help with, then follow the instructions from there.
