Cách Sửa Lỗi Runtime Error 1004 Excel, Tổng Hợp Lỗi Run Time ...

In this post, I have included the complete information about Excel runtime error 1004.

Đang xem: Lỗi runtime error 1004 excel

Besides that I have presented some best fixes to resolve runtime error 1004 effortlessly.

MS Excel is a very popular spreadsheet and is used worldwide for storing, organizing and manipulating data. This is used for both the individual and business purposes; this comes in two extensions XLS and XLSX format. But apart from its popularity, it is found this gets corrupted and due to this, it starts showing Runtime error 1004.

Here in this article, we are going to discuss about this commonly faced runtime error 1004 in Excel 2019, 2016 2013 and earlier versions.

Contents

• 0.1 What Is Runtime Error 1004 In VBA Excel?
• 0.2 List of Commonly Found Runtime Error 1004 VBA:
• 0.3 Why This Visual Basic Runtime Error 1004 Occurs?
• 1 How To Fix Runtime Error 1004
  • 1.1 METHOD 1: Uninstall Microsoft Work
  • 1.2 METHOD 2: Create New Excel Template
  • 1.3 METHOD 3: Delete The “GWXL97.XLA” File
• 2 Automatic Solution: MS Excel Repair Tool

What Is Runtime Error 1004 In VBA Excel?

Excel error 1004 is one such annoying runtime error that mainly encounters while working with the Excel file. Or while trying to generate a Macro in Excel document and as a result, you are unable to do anything in your workbook.

This error may cause serious trouble while you are working with Visual Basic Applications and can crash your program or your system or in some cases, it freezes for some time. This error is faced by any versions of MS Excel such as Excel 2007/2010/2013/2016/2019 as well.

ERROR DETAIL:

Error Code: run-time error 1004

Description:Application or object-defined error

Screenshot Of The Error:

Don’t worry you can fix this Microsoft Visual Basic runtime error 1004, just by following the steps mentioned in this post. But before approaching towards the fixes section catch more information regarding runtime error 1004.

List of Commonly Found Runtime Error 1004 VBA:

The lists of error messages associated with this Excel error 1004 are:

VB: run-time error ‘1004’: Application-defined or object-defined errorExcel VBA Runtime error 1004 “Select method of Range class failed”runtime error 1004 method range of object _global failed visual basicExcel macro “Run-time error ‘1004″Runtime error 1004 method open of object workbooks failedRun time error ‘1004’: Method ‘Ranger’ of Object’ Worksheet’ FailedSave As VBA run time Error 1004: Application defined or object defined error

Why This Visual Basic Runtime Error 1004 Occurs?

Follow the reasons behind getting the run time error 1004:

Due to corruption in the desktop icon for MS ExcelConflict with other programs while opening VBA Excel fileWhen filtered data is copied and then pasted into MS Office Excel workbookDue to application or object defined errorA range value is set programmatically with a collection of large string.

Well, these are common reasons behind getting the VBA runtime error 1004, now know how to fix it. Here we have described both the manual as well as automatic solution to fix the run time error 1004 in Excel 2016 and 2013. In case you are not able to fix the error manually then make use of the automatic MS Excel Repair Tool to fix the error automatically.

How To Fix Runtime Error 1004

Follow the steps given below to fix Excel run time error 1004 :

METHOD 1: Uninstall Microsoft Work

1. Go to the Task Manager and stop entire running programs.

2. Then go to Start menu > and select Control Panel.

3. Next, in the Control Panel select Add or Remove Program.

4. Here, you will get the list of programs that are currently installed on your PC, and then from the list select Microsoft Work.

5. And click on uninstall to remove it from the PC.

Xem thêm: Get Zalo Desktop – Zalo For Windows 10

It is also important to scan your system for viruses or malware, as this corrupts the files and important documents. You can make use of the best antivirus program to remove malware and also get rid of the runtime error 1004.

METHOD 2: Create New Excel Template

Another very simple method to fix Excel runtime error 1004 is by putting new Excel worksheet file within a template. Instead of copying or duplicating the existing worksheet.

Here is the complete step on how to perform this task.

1.Start your Excel application.

2. Make a fresh new Excel workbook, after then delete the entire sheets present on it leaving only a single one.

3. Now format the workbook as per your need or like the way you want to design in your default template.

4. Excel 2003 user: Tap to the File>Save As option

OR Excel 2007 or latest versions: Tap to the Microsoft Office button after then hit the Save As option.

5. Now in the field of File name, assign name for your template.

6. On the side of Save as type there is a small arrow key, make a tap on it. From the opened drop menu

Excel 2003 users have to choose the Excel Template (.xlt)

And Excel 2007 or later version have to choose the Excel Template (.xltx)

7. Tap to the Save

8. After the successful creation of the template, now you can programmatically insert it by making use of following code:Add Type:=pathfilename

Remarks: 

From the above code, you have to replace the pathfilename with the complete path including the file name. For assigning the exact location of the sheet template you have just created.

METHOD 3: Delete The “GWXL97.XLA” File

Follow another manual method to fix Excel Runtime Error 1004:

1. Right click on the start menu.

2. Then select the Explore option.

3. Then open the following directory – C:Program FilesMSOfficeOfficeXLSTART

4. Here you need to delete “GWXL97.XLA” file

5. And open the Excel after closing the explorer

You would find that the program is running fine without a runtime error. But if you are still facing the error then make use of the automatic MS Excel Repair Tool, to fix the error easily.

Xem thêm: Khắc Phục Lỗi Camera Iphone 6, Mẹo Giúp Sửa Chữa Iphone 6/6S Bị Lỗi Camera

Automatic Solution: MS Excel Repair Tool

MS Excel Repair Tool is a professional recommended solution to easily repair both .xls and .xlsx file. It supports several files in one repair cycle. It is a unique tool that can repair multiple corrupted Excel file at one time and also recover everything included charts, cell comments, worksheet properties and other data. This can recover the corrupt Excel file to a new blank file. It is extremely easy to use and supports both Windows as well as Mac operating system.