How to Fix Excel File Runtime Error 1004

How to Fix Excel File Runtime Error 1004

Excel runtime error 1004 is the common and annoying error that users face while using Microsoft Excel. This article provides solutions to resolve the runtime errors.

Wondershare Recoverit Authors

Sep 18, 2020 • Filed to: Recover & Repair Files • Proven solutions

0

Microsoft Excel is the most popular data manipulation application used by millions of users across the globe. This application can be used by both personal and business-related data storage and display. But a common “runtime error 1004” might be distracting as it stops the application by affecting MS Excel or XLS/XLSX files.

This blog provides the list of common errors found when an excel file is running and also the best methods that can resolve the excel runtime error 1004. This error can cause very serious damage to your excel file and might lead to a program crash. Let us go through the article and get rid of the unexpected and unwanted runtime error 1004.

Part 1: Common Excel Run-time 1004 Errors and Issues

Below is the list of common errors displayed related to excel runtime error 1004:

Part 2: How to Fix Excel Runtime Error 1004

Fix 1: Uninstall Microsoft Work

Excel runtime error 1004 is the error that occurs when the excel file is corrupted. This can be resolved by Uninstalling Microsoft Work by following the below steps:

click-on-control-panel

uninstall-microsoft-works

Fix 2: Delete The “GWXL97.XLA” File

If the above method doesn’t resolve the error 1004, you can delete the “GWXL97.XLA” file by following the below steps:

gwxl97-1

 

gwxl97-2

 

Fix 3: Create New Excel Template

If you are not able to open the excel file after deleting the “GWXL97.XLA” file, then follow the simple process of creating a new excel template by following the below steps:

Step 1 – Launch the excel application.

Step 2 – Click on the “Office” symbol and click on “Save As”.

new-excel-template-1

Step 3 – On the side menu, select “Excel Workbook”.

Step 4 – From the drop-down menu of “Save as Type”, select “Excel template”.

Step 5 – Select the corrupted excel file and click on “Save”.

new-excel-template-2

Part 3: Free Download Excel File Repair Tool

If MS Excel is issuing the excel file runtime error 1004 when you are trying to open your excel files then there is surely a problem with it. You can fix excel file runtime error 1004 by using a good excel repair tool. However, finding such a tool isn’t that easy. There aren’t many excel repair tools that can fix this error message. Stellar Phoenix Excel Repair is among the few repair tools that can fix Excel file runtime error 1004.

Microsoft Excel Repair Tool
  • Recovers all kinds of data stored in damaged excel files such as tables, charts, formulas, comments, images, etc.
  • Restore all of your corrupted excel files to their original standing.
  • Preview the repaired excel file in real-time, see how much of the file has been recovered as it is being repaired.
  • All kinds of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can be used on both Windows and Mac platforms to repair corrupt excel file.
  • All kinds of MS office corruption errors (for XLS and XLSX files only) can be handled with this tool.
  • This excel file repair tool can repair damaged files of all versions from 2000 to 2016 that includes 2000, 2003, 2007, 2010, 2013, etc.
 

Stellar Phoenix Excel Repair is an efficient excel repair tool. It can fix excel file runtime error 1004 safely and effectively within a few seconds.

Part 4: How to Fix Excel File Runtime Error 1004

Here is a step-by-step instruction guide that has been generated to cater to the needs of the users of Stellar Phoenix Excel Repair. It helps them in learning how to fix excel file runtime error 1004 with this wonderful excel repair tool.

Step 1 Clicking any one of the following buttons, ‘Search Files’, ‘Select Folder’, or ‘Select File’. To search for the corrupted excel file from the system.

fix excel file runtime error 1004 step 1

Step 2 All corrupt Excel file display in the result section, by clicking the ‘Scan’ button to start the repairing process.

fix excel file runtime error 1004 step 2

Step 3 Double-clicking the file to previewing of the corrupted excel file

fix excel file runtime error 1004 step 3

Step 4 The last guide is concerned with the repairing and saving of the corrupted excel file

fix excel file runtime error 1004 step 4

Some useful tips:

If you are fed up with the constant corruption of your excel files then you must try to find a permanent solution for this problem. The following tips might come in handy in this regard.

The Bottom Line

As excel application has all the important data related to your business or company, it will be very annoying if it does not open. This article will help you to resolve the error and open the corrupt excel file. The manual and automatic solutions or methods are given in this article will help you in resolving the “runtime error 1004”. Initially try to uninstall Microsoft works, if it doesn’t work, go and delete the GWXL97.XLA file from your computer. If these two don’t provide you a solution then you can open the excel workbook as a template and start working on it.

Recoverit author

Amy Dennis

staff Editor

(Click to rate this post)

Generally rated4.5(105participated)

Home > Resources > Recover & Repair Files > How to Fix Excel File Runtime Error 1004