Thursday, July 16, 2015

How to Fix Excel Runtime Error 1004?


Is your excel file is showing run time error 1004? This error generally comes when you are working on MS Excel or you trying to generate a Macro in Excel document. After having this error you can’t proceed your work further.

Common Runtime Error:

 Other error messages that come along with this runtime error are as follows:
  1. Excel macro Run-time error ‘1004
  2. Run-Time error ‘1004’: Method ‘Ranger’ of Object’ Worksheet’ Failed
  3. Runtime error 1004 method open of object workbooks failed
  4. Excel VBA Runtime error 1004 “Select method of Range class failed”
  5. VB: run-time error ‘1004’: Application-defined or object-defined error
  6. Save As VBA Run-time Error 1004:Application defined or object defined error
  7. runtime error 1004 method range of object _global failed visual basic

Reasons for this runtime error:

The reasons to get this error are as follows:
  •   MS Excel desktop icon get corrupted
  •  At the time of opening VBA Excel file, conflict with other programs
  • When you copy filtered data and paste it into MS Office Excel workbook
  • Application or object defined error
  •  A range value is set programmatically with a collection of large string.

Solutions for Runtime error 1004:

 To fix this error manually you can follow these steps:
  1. Open Task Manager and stop all running program.
  2. From the start menu select Control Panel.
  3. In the control panel select Add or Remove Program
  4. Here you will get the list of programs that are currently installed in your PC, from this list select the MS office program.
  5. Now click on uninstall to remove it from the PC.

Another method to fix this problem is mentioned below:
  1. Right click on the start menu
  2.  Then select the Explore option
  3. Then open the following directory – C:\Program Files\MSOffice\Office\XLSTART
  4. Here you have need to delete “GWXL97.XLA” file
  5. Now open the excel after you closing the explorer
If still after performing these manual steps you are facing the same problem, then to fix this you have the last but not the least solution that is make use of Excel Repair Tool.  As this tool is best suited to detect any kind of Excel error and to fix them. It has equipped with so many features that can easily help you to fix any kind of error and also recover the data quickly and easily.

1 comment:

  1. Excel file recovery tool is a powerful utility to repair corrupt Excel xls & xlw files. It can scan the corrupt files and recover your data in them as much as possible. It is integrated with Windows shell, supports drag & drop operations, and command line parameters which will make you repair files easily and quickly.

    To download:- http://www.softmagnat.com/excel-recovery.html

    ReplyDelete