Fix : Excel Cannot Complete This Task With Available Resources Error in MS Excel on Windows 11 / 10

Microsoft Excel is a widely used application by users around the world to store and manage their data. But, there are errors faced with this application that can be annoying to the users as their data can get corrupted and they may not be able to open the file at all. Many users have reported seeing an error message as below


ADVERTISEMENT

Excel cannot complete this task with available resources. Choose less data or close other applications.

Generally, this error is seen in Excel files that have large amounts of data, complex formulas, and macros. The system may show this error as the resources needed to process such a workbook is not available.

Possible causes for  this error are:

  • Trying to open or save an Excel file
  • Using a defined name in a formula in the spreadsheet
  • Opening a workbook that references a relative name from another Excel workbook.
  • Defining or deleting a name in the file
  • More than one active instance of Excel is opened on your PC
  • Low processing capacity of RAM

 

If you have been troubled with errors in MS Excel, then you are in the right post. In this article, we have discussed some solutions based on user surveys that helped them solve this issue on their computers. Before trying the fixes, perform a system restart and check if it helps resolve this error.

Fix 1 – Ignore applications using DDE

1 – Click on File Tab in excel

2 – Click on Options from left menu located at bottom

Options Excel Min

 

3 – Click on Advanced from left menu of Excel options

4 -In the right side of Excel options, keep scrolling down until you find , Ignore other applications that use Dynamic Data Exchange (DDE)

5 -Click Ok.

 

Ignore Apps Dde Min

Try again.

Fix 2 – Check for Exceeding Defined Limits in the Excel File

 

MS Excel has certain defined limits that need to be followed else it may result in errors like this. So you need to check whether these limits are exceeded like having many calculations or storing large amounts of data and so on.

Some of the limits defined in excel are as below:

1. Maximum size limit for the workbook is  1,048,576 rows by 16,384 columns.

2. The maximum number of characters that a particular cell can have is 32,767 characters.

3. 2048 is the max selected range for a calculation.

4. A calculation can have a maximum of  64 nested levels of functions.

If all the limits are being followed in your Excel worksheet then move to the next fix.

 

Fix 3 – Open Only One Instance of Excel

 

At times without your knowledge, there will be many instances of Excel workbook running on the system. All these instances need to be closed and your error Excel sheet needs to be reopened to check if it fixes the issue.

 

1. Press Ctrl + Shift + Esc to open Task Manager.

2. In the Task Manager, go to the Processes tab.

3. Expand the Apps section to see the applications currently running.

4. Locate Microsoft Excel and check whether there are any other instances currently running.

Note: Make sure that you have saved your Excel worksheets before ending them.

5. Select each Excel instance and click on the End task button to stop the processes.


ADVERTISEMENT

 

Task Manager End Excel Task Min

 

6. Check to see there are no Excel instances in the Task Manager.

7. Now open the problematic Excel file and check if the error is resolved. If the problem still persists, then go to the next method.

 

Fix 4 – Open Excel in Safe Mode

 

1. Press the Windows and R key combination to open Run.

2. Type excel /safe and hit Enter.

 

Run Excel Safe Mode Min

 

3. Now Excel opens in Safe mode. You will see Book1 – Microsoft Excel – Safe Mode as the title of the Excel window.

4. Click on the File menu.

 

Excel Open In Safe Mode File Menu Min

 

5. Select Open and then click on Browse to select your problematic Excel file.

 

Excel Open Browse Min

 

6. Open this Excel file and check if the problem still occurs or not.

 

Fix 5 – Disable Details and Preview Pane in Windows Explorer

 

The preview pane allows you to have a look at the file contents before you open it. If the preview pane is enabled, it may conflict with the Excel worksheet and cause this error. Follow the steps to disable it.

 

1. Press the Windows + E to open the File Explorer.

2. Click on the View tab at the top.

3. In the drop-down menu, move over to the Show option.

4. Here, if the Preview Pane/Details Pane button is checked it means it is enabled.

5. Click on the Preview Pane and Disable Pane to disable/hide it.

 


ADVERTISEMENT


File Explorer Uncheck Details Preview Pane Min

 

6. Open your Excel worksheet and check if the error is fixed.

 

If it doesn’t work, try turning off the Detail Pane and Preview Pane in Excel.

1. Launch Excel application.

2. Press Ctrl + O to go to the Open tab.

3. Click on Browse.

 

Excel Open Browse To Open File Min

 

4. In the Open window, click on the Organize button at the top left corner.

5. Go to the Layout option in the dropdown menu.

6. Now, uncheck Details Pane and Preview Pane if it is enabled.

 

Open Window Disable Detail Preview Pane Min

 

 

Fix 6 – Change Defined Names to Reference Cells Directly

 

When you have defined names that are indirectly referring to some other nested names more than 20 levels deep, this error can be shown to the user. To overcome the error due to defined names, you can do the following:

1. Add or make use of a name that exceeds the indirection level present in the formula.

2. Remove any name that is being referenced by more than 20 levels of defined names.

Try as much as possible to reference the cells directly by modifying the defined names.

 

Fix 7 – Remove Unwanted Formatting

 

1. Open the Excel workbook.

2. Press Ctrl + A to select all the entries in the sheet.

3. In the Home tab, click on Clear (eraser icon) on the right side in the Editing section.

4. Choose Clear Formats.

 

Excel Home Clear Formats Min

 

If the problem still exists, try the next fix.

 

Fix 8 – Turn Off Automatic Calculations

 

Whenever any changes are been made in the Excel sheet, it by default calculates the formulas in the sheet automatically. You can change this setting to manual using the steps below.

 

1. Click on the File menu.

 

Excel File Menu Min

 

2. Select Options at the bottom.

 

Excel Optiosn Min

 

3. In the Excel Options window, go to the Formulas tab.

4. Under Calculations options, select the radio button next to Manual.

5. Click on OK to close the Excel Options window.

 

Excel Options Formulas Manual Min

 

6. If you want to perform any cell calculations manually, select the Formulas tab in your Excel worksheet.

7. Tap the Calculate now button in the Calculation section on the right side.

 

Excel Formulas Calculate Now Min

 

Fix 9 – Close all Background Applications

 

1. Open Task Manager using the Ctrl, Shift, and Esc key combination.

2. Select the Details tab.

3. Here, look for the program or service that you want to stop from running. Select this process/service and click on the End task button.

Note: Don’t end any process where the username is SYSTEM.

 

Task Manager Details End Task Min

 

 

Fix 10 – Permanently Disable  Background/Startup Applications

 

1. Press Windows + R to open Run.

2. Type msconfig and hit Enter to open System Configuration.

 


ADVERTISEMENT

Run Msconfig1 Min

 

3. Go to the General tab.

4. Make sure that you have selected the option Selective startup.

 

System Config Selective Startup Min

 

5. Select the Startup tab.

6. Click on Open Task Manager.

 

System Config Startup Open Task Manager Min

 

7. In the Task Manager’s Startup tab, select the application that is not needed and click on Disable button. Disable all the applications that are not needed.

 

Task Manager Disable Startup Items Min

 

8. Close the Task Manager and go back to System Configuration.

9. Go to the Services tab.

10. Here, check the box associated with the option Hide all Microsoft Services.

11. To disable all the running services click on the Disable all button.

12. Click on OK.

 

System Config Services Disable Hide Microsoft Services Min

 

13. Click on Restart to reboot your PC. Check if the issue with the Excel file is solved after startup.

 

System Config Restart After Changes Min

 

 

Fix 11 – Hardware & Software Upgrades

1. Try increasing the system’s RAM. For example, if you have 4 GB RAM then increase it to 8GB or more.

2. Upgrade Excel to 64-bit so that it can handle larger workbooks easily by taking the benefit of more than 2GB RAM.

That’s it.

MS Excel must now be free of the error that indicates the resources are not enough to complete the task. Comment and let us know the fix that helped you overcome this error.

ADVERTISEMENT