How to Fix Runtime Error 1004 in Excel? 6 Easy Steps

Fix all your Excel and PC errors with iobit Advanced SystemCare & enhance your online security.

Below are the most commonly encountered Runtime 1004 errors; although the exact error message may vary, the error code remains the same:

1. “Run-time error 1004: Application or Object-defined error”.
2. “Excel VBA Runtime error 1004: Select method of Range class failed”.
3. “Excel macro Run-time error 1004”.
4. “Run-time error 1004: Method Range of Object Worksheet failed”.
5. “Run-time error 1004: Copy Method of Worksheet Class failed”.
6. “Run-time error 1004: Cannot run the Macro in Excel”.

Now, that we have a basic understanding of this error, let’s begin with the solutions:

6 Solutions to Fix Runtime Error 1004 in Excel

Fix 1: Uninstall Microsoft Works

In some cases, conflicts with “Microsoft Work” may trigger “Runtime Error 1004”. It’s an old app that might cause issues if you’re still using it.
To resolve this, consider uninstalling “Microsoft Work”, if installed. This can be done through the “Control Panel” on your computer. Here are detailed steps:

• Press the ‘Win+S’ keys and type “Control Panel” and open the “Control Panel” on your computer 
• Navigate to “Programs” and then “Programs and Features”.
• Look for “Microsoft Works” in the list of installed programs.
• Right-click on “Microsoft Works” and select “Uninstall”.

• Follow the prompts on-screen to complete the uninstallation process.

Fix 2: Delete “GWXL97.XLA” File

The presence of the “GWXL97.XLA” file may lead to runtime errors. Deleting this file can help in resolving the issue. Here’s how you can do it:

• Open “File Explorer” and navigate to the Excel Folder, you can follow the directory: C:\Program Files\MSOffice\Office\XLSTART
• Search for the “GWXL97.XLA” file.
• Right-click on the file and select “Delete”.
• Confirm the deletion when prompted.

• Now, reopen “Excel” and try to run the worksheet.

*Please note that the path mentioned may vary depending on the installation location and version.

Fix 3: Create a New Excel Template

Runtime Error 1004 may also be caused by a corrupted Excel template. Create a new template by saving a blank workbook as the default template. This can often resolve issues related to corrupted templates. Follow the below steps:

• Open a new, blank workbook in “Excel”. Ensure to keep only one worksheet in the workbook.
• Customize the workbook to your preferences or leave it blank.
• Now save the file using “Save as” and if you are using a 2003 or earlier version of Excel, save the workbook as the Excel Template (.xlt) and if you are using a 2007 or later version, use Excel Template (.xltx).

• After saving the document successfully, you can use the following code to insert the template: Sheets.Add Type:=path\filename
• Replace “filename” with the specific name of the document.

Fix 4: Check the Trust Access to the VBA

Ensure that your Excel settings allow trust access to the VBA project. This can help resolve the error. Here are the steps:

• Open “Excel” and go to the “File” tab.
• Click on “Options” at the bottom of the left-hand menu.
• Select the “Trust Center” option in the left-hand menu within the Excel “Options” window.
• Click on “Trust Center Settings”.

• Choose “Macro Settings” in the Trust Center dialog box.
• Now, check the checkbox next to “Trust access to the VBA project object model”, select the “Enable all Macros” option and click “OK”.

• Reopen “Excel” once done and check if the error has been resolved.

Fix 5: Repair Corrupted Excel File

Corrupted Excel files can contribute to “Runtime Error 1004”. You can utilize Excel’s built-in repair tool for this purpose. We suggest backing up data before attempting to repair a corrupted file. Here’s how you can repair a file:

• Open Excel and go to the “File” tab.
• Choose “Open”, and then select the corrupted Excel file.
• Click the arrow next to the “Open” button and choose “Open and Repair”.

• Follow the prompts to repair the file.

Fix 6: Repairing or Reinstalling Excel

If none of the previous solutions work, you can try repairing or reinstalling Microsoft Excel. 

• Open the “Control Panel” on your computer.
• Navigate to “Programs” and then “Programs and Features”.
• Locate “Microsoft Office” in the list of installed programs.
• Right-click on “Microsoft Office” and choose either “Change/Repair” or “Uninstall”.

• Follow the on-screen prompts to repair or reinstall “Microsoft Office”.

And that’s all, guys! We genuinely hope that by following these step-by-step solutions, you effectively solved Runtime Error 1004 in Excel. Be it adjusting settings, deleting problematic files, or repairing Excel itself, these steps are designed to ensure a smoother experience, allowing you to seamlessly continue your work with MS Excel.