How to Fix Runtime Error 1004 in Excel?

MS Excel is the very useful application of MS Office and it is used for making spreadsheet, storing, organizing and manipulating data. This software is utilized in homes as well as for business purposes. You can install MS Excel application through office.com/setup. It has two extensions XLS and XLSX format. It is easy to use but some users face the Runtime error 1004.

This error basically occur due to corruption in MS Excel icon, conflict with other programs when you open VBA Excel file, when filter data is copy and paste in MS Office Excel workbook, due to application error, and if program range value is incorrectly set. In this blog, you will read the solution for the runtime error 1004 in Excel.

Fix Runtime Error 1004 in Excel:

  1. Uninstall Microsoft Works: For this, first you have to go to the Task Manager and then you have to stop entire running programs. After this, you have to go to Start menu and then you have to select Control Panel. Now in the Control Panel, you have to select Add or Remove Program. Here, you will see the list of programs which are installed on your computer and from this list you have to select Microsoft Work. At the end, you have to click on uninstall to remove Microsoft Work from your computer.
  2. Delete GWXL 97.XLA File: First you have to right click on the start menu. Then you have to select the Explore option. After this, you have to open the following directory C:\Program Files\MSOffice\Office\XLSTART
    Now you have to delete “GWXL97.XLA” file. After this, close the explorer and open the Excel.
  3. Create New Excel Template: For this, first you have to start your Excel application. Then you have to create a new Excel workbook. Now you have to delete the entire sheets present on it and just have to leave only a single one. After this, you have to format the workbook according to your need. Here you have to click on the MS Office button and then select Save As option. From the Save as option, you have to select Template for the Save As Type. Now in the File name field, you have to name for your template. At the end, click on Save option. You can programmatically insert the template by using following code:
    Add Type:=path\filename
  4. Visual Basic Fix: First open Microsoft Excel, you have to click on the Office Button, and then you have to click on Excel Options. When Excel Options loads up, you have to click on the Trust Center Tab. After this, you have to click on Trust Center Settings.In the Trust Center Options, you have to click on the Macro Settings Tab, and then you have to click on Trust access to the VBA project object model. At the end, just click on OK button.

These solution will fix the runtime error 1004 in Excel, incase if you have any problem then contact to the customer care executive of MS Office through www.office.com/setup.