使用Office 365 Excel应用程序时，您可能会收到指向“ Excel 无法完成此任务、内存不足或系统资源不足无法完全显示(Excel cannot complete this task, Out of Memory or Not enough System Resources to Display Completely)”情况的错误。在这篇文章中，我们将介绍如何解决此问题并继续使用Excel 文件(Excel File)。
修复 Excel 内存不足错误
以下是在这种情况下可能出现的错误列表：
- Excel 无法使用可用资源完成此任务。选择(Choose)更少的数据或关闭其他应用程序。
- 内存不足
- 没有足够的系统(System) 资源(Resources)来完全显示(Display)
- 内存不足，无法完成此操作。尝试使用更少的数据或关闭其他应用程序。要提高内存可用性，请考虑：
- 使用 64 位版本的Microsoft Excel。
- 为您的设备添加内存。
内存不足，无法完成此操作Excel错误
重要的是要注意错误消息是一般性的，但有一点很清楚，Excel应用程序无法处理大文件大小。该文件非常大，以至于消耗了系统可用的全部内存。如果您的Excel文件很大或有很多公式和脚本，则系统可能内存不足。也就是说，微软已经正式分享了(Microsoft)Excel的一些限制。
- Excel：规格和限制(Specifications and limits)
- Excel 性能：性能和限制改进(Performance and Limit Improvements)
- Excel：32 位版本中的内存使用情况(Memory usage in the 32-bit edition)
记住这一点，让我们知道如何解决错误消息。
Excel 无法使用可用资源完成此任务
- 安装更新
- 文件特定问题
- 干扰加载项
- 使用 64 位版本的Excel进行测试(Excel)
- 添加物理内存
- 更改默认打印机
- 不使用杀毒软件进行测试
很明显，您需要更多内存。您可能会查看其他正在消耗内存的应用程序并摆脱它们。您可以终止此类应用程序，并阻止它们在后台运行。
系统(System) 资源(Resources)不足，无法完全显示 Excel(Display Completely Excel)错误
1]安装更新
有时可能是因为以前的更新或Microsoft已发布更新来处理此类情况。我强烈建议您在遵循任何进一步的建议之前检查(check for any update)您的操作系统和Office软件的任何更新并安装它。
2]文件特定问题
如果仅一个文件发生错误，则您可能需要重新访问文件的内容。这可能是因为当您复制粘贴此类单元格、复杂数据透视(PivotTables)表、宏和具有许多数据点的复杂图表、自定义视图等时，会发生大量计算。
您需要通过在受保护的视图(Protected View)中打开它或禁用VPA功能等来手动检查它。请记住(Remember)，打开文件时不会发生错误，但是当执行大量计算或插入新数据超出Excel的容量时会发生错误。
您可能还希望将 excel 文件分解为更小的文件，以便以更好的方式处理这种情况。
3]干扰加载项
如果您在Excel(Excel)中安装了插件或加载项，最好禁用并检查您是否仍然遇到问题。如果您没有遇到任何问题，那么您需要检查是否有可用的加载项更新。有时加载项(Add-ins)会占用大量资源来完成一项任务，这会导致内存不足(Memory)，(Out)系统(System)资源(Resources)不足，无法完全显示(Display Completely)的问题。
4]尝试(Try)使用 64 位版本的Excel
64 位版本的Microsoft Office可以比 32 位 Excel 应用程序更好地处理大文件。这是因为任何 32 位应用程序都有 2 GB 的限制。如果您几乎每天都需要处理大文件，最好下载或迁移到Microsoft Excel 64位版本。它将能够访问更多RAM并更快地完成工作，而不会导致内存(Memory)不足(Out)问题。
5]为您的计算机添加(Add)更多物理内存
如果它是您用完的物理内存，那么是时候为您的计算机添加更多 RAM。如果您要切换到 64 位版本，那么添加额外的内存将帮助您更快地处理Excel文件。
6]更改默认打印机
当Excel启动时，它会轮询默认打印机。有时，如果打印机不可用或由于数据太多无法处理而没有响应，它可能会卡住。我们建议您将默认打印机更改为计算机上可用的虚拟打印机之一，例如PDF打印机或 XPS 文档编写器。
- 打开 Windows 设置 (WIN + I)
- 导航(Navigate)到设备(Devices)>打印机(Printers)和扫描仪
- 取消选中“让 Windows(Let Windows)管理我的默认打印机”框
- 选择其中一台(Select one)虚拟打印机，然后单击管理(Manage)按钮
- 单击(Click)管理(Manage)您的设备部分下的设置(Set)为默认按钮
再试一次，看看这次是否正常。
7]禁用防病毒软件
众所周知，防病毒(Antivirus)软件会导致这些类型的问题，尤其是当它们最终一次又一次地扫描文件时。如果文件中的防病毒软件会损害计算机，也可能是误报。大多数防病毒软件都提供临时禁用选项(antivirus offer a temporary disable option)。因此，请在执行此操作后重试或完全卸载 AV 以检查问题是否已解决。
让我们知道这里是否对您有所帮助。
Excel cannot complete this task, Out of Memory, Not enough Resources
When using Office 365 Excel appliсation, you may receive an error that wоuld point to “Excel cannot complete this task, Out of Memory or Not enough System Resources to Display Completely” condition. In this post, we are offering how you can resolve this problem and continue to use the Excel File.
Fix Excel Out of Memory error
Here is the list of errors that can show up under this situation:
- Excel cannot complete this task with available resources. Choose less data or close other applications.
- Out of Memory
- Not enough System Resources to Display Completely
- There isn’t enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider:
- Using a 64-bit version of Microsoft Excel.
- Adding memory to your device.
There isn’t enough memory to complete this action Excel error
It is important to note that the error message is general, but one thing is clear that the Excel app is not able to process large file sizes. The file is so huge that it consumes the whole memory available to the system. If your Excel file is large or has a lot of formulas and scripts, the system may run low on memory. That said, Microsoft has officially shared some limitations for Excel.
Keeping this in mind, let us know how we can resolve the error message.
Excel cannot complete this task with available resources
- Install Updates
- File Specific Issue
- Interfering Add-ins
- Test with the 64-bit version of Excel
- Add Physical RAM
- Change the default Printer
- Test without Antivirus
It is apparent that you need more memory. You may look at the other applications that are consuming the memory and get rid of them. You can terminate such applications, and stop them from running in the background.
Not enough System Resources to Display Completely Excel error
1] Install Updates
Sometimes it could be because of a previous update or Microsoft have released an update to handle these kinds of situations. I would highly recommend you to check for any update for your OS as well as Office software and install it before following any further suggestion.
2] File Specific Issue
If the error is occurring for only one file, then you may need to revisit the content of the files. It could be because of the high number of calculations when it happens when you copy-paste such cells, complex PivotTables, macros, and complex charts with many data points, custom views, and so on.
It is something you need to manually check by opening it in Protected View or disabling VPA features and so on. Remember, the error will not occur when you open a file, but it will happen when it performs a heavy calculation or when you insert new data goes beyond the capacity of Excel.
You may also want to break the excel file into smaller files to handle the situation in a better way.
3] Interfering Add-ins
If you have plugins or add-ins installed in Excel, it would be a good idea to disable and check if you still face the issue. If you do not face any problem, then you need to check if there is an update for the add-in available. Sometimes Add-ins take a high amount of resources to complete a task, which results in Out of Memory, Not enough System Resources to Display Completely problem.
4] Try with the 64-bit version of Excel
A 64-bit version of Microsoft Office can handle large files better than the 32 bit Excel application. It is because there is a limit of 2 GB for any 32-bit application. If you need to handle large files almost every day, it is better to download or move to Microsoft Excel 64 bit version. It will be able to access more RAM and get things done faster without resulting in Out of Memory issue.
5] Add more physical memory to your computer
If it is the physical memory you are running out of, then its time you add more RAM to your computer. If you are switching to a 64-bit version, then adding extra memory will help you process the Excel file a lot faster.
6] Change the default Printer
When Excel launches, it polls for the default printer. At times, it may get stuck with if the printer is not available or doesn’t respond because the data is too much to handle. We will recommend you to change your default printer to one of the virtual printers available on the computer such as PDF printer or XPS document writer.
- Open Windows Settings (WIn + I)
- Navigate to Devices > Printers and Scanners
- Uncheck the box which says Let Windows manage my default printer
- Select one of the virtual printers, and click on Manage button
- Click on Set as default button under Manage your device section
Try again, and see if it works fine this time.
7] Disable Antivirus
Antivirus software is known to cause these types of problems, especially if they end up scanning the file again and again. It can be a false positive as well if the antivirus things the file can harm the computer. Most of antivirus offer a temporary disable option. So try again after doing that or completely uninstall the AV to check if the issue is resolved.
Let us know if anything here helped you.
