{"id":84,"date":"2015-07-09T12:55:48","date_gmt":"2015-07-09T12:55:48","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=84"},"modified":"2021-08-19T11:53:11","modified_gmt":"2021-08-19T11:53:11","slug":"how-to-fix-runtime-error-1004","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004","title":{"rendered":"How To Repair Runtime Error 1004 in Excel?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<blockquote>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><em><b>\u00a0Summary:<\/b><\/em><\/span><\/p>\n<p style=\"text-align: justify;\"><em>In this post, I have included the complete information about <strong>Excel runtime error 1004.<\/strong> Besides that I have presented some best fixes to resolve<strong> runtime error 1004<\/strong> effortlessly.<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>To fix Runtime Error 1004 in Excel you can take initiatives like uninstalling Microsoft Work, creating a new Excel template, or deleting The &#8220;GWXL97.XLA\u201d File. If you don&#8217;t have any idea on how to apply these methods then go through this post.<\/strong><\/p>\n<p style=\"text-align: justify;\">Here in this article, we are going to discuss different types of <strong>VBA<\/strong> <strong>runtime error 1004 in Excel <\/strong>along with\u00a0their fixes.<!--more--><\/p>\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">What Is Runtime Error 1004 In VBA Excel?<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/answers.microsoft.com\/en-us\/office\/forum\/office_2007-excel\/excel-vba-run-time-error-1004-application-defined\/0211771e-8f9a-478a-9c61-ad00aaaaabfe\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Excel error 1004<\/strong><\/a> is one such annoying <strong>runtime error <\/strong>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.<\/p>\n<p style=\"text-align: justify;\">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 <strong>Excel 2007\/2010\/2013\/2016\/2019<\/strong> as well.<\/p>\n<p style=\"text-align: justify;\"><div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover lost Excel data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Error Detail:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Error Code:<\/strong> run-time error 1004<\/p>\n<p style=\"text-align: justify;\"><strong>Description: <\/strong>Application or object-defined error<\/p>\n<p style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Screenshot Of The Error:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5785 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/excel-error-1004.png\" alt=\"run-time error 1004\" width=\"367\" height=\"208\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/excel-error-1004.png 367w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/excel-error-1004-300x170.png 300w\" sizes=\"auto, (max-width: 367px) 100vw, 367px\" \/><\/p>\n<p style=\"text-align: justify;\">Don&#8217;t worry you can fix this <strong>Microsoft Visual Basic runtime error<\/strong> <strong>1004<\/strong>, just by following the steps mentioned in this post. But before approaching the fixes section catch more information regarding <strong>runtime error<\/strong> <strong>1004.<\/strong><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Excel VBA Run Time Error 1004 Along With The Fixes<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2976 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/excel-formula-not-working.png\" alt=\"EXCEL ERRORS\" width=\"492\" height=\"277\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/excel-formula-not-working.png 750w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2016\/12\/excel-formula-not-working-300x169.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/p>\n<p style=\"text-align: justify;\">The lists of error messages associated with this <strong>Excel error 1004<\/strong> are:<\/p>\n<ol style=\"text-align: justify;\">\n<li><em><span style=\"color: #ff0000;\">VB: run-time error \u20181004\u2019: Application-defined or object-defined error<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">Excel VBA Runtime error 1004 \u201cSelect method of Range class failed\u201d<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">runtime error 1004 method range of object _global failed visual basic<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">Excel macro \u201cRun-time error \u20181004\u2033<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">Runtime error 1004 method open of object workbooks failed<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">Run time error \u20181004\u2019: Method \u2018Ranger\u2019 of Object\u2019 Worksheet\u2019 Failed<\/span><\/em><\/li>\n<li><em><span style=\"color: #ff0000;\">Save As VBA run time Error 1004: Application defined or object defined error<\/span><\/em><\/li>\n<\/ol>\n<p>Let&#8217;s discuss each of them one by one&#8230;!<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#1 \u2013 VBA Run Time Error 1004: That Name is already taken. Try a different One<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">This <strong>VBA Run Time Error 1004 in Excel<\/strong> mainly occurs at the time of renaming the sheet.<\/p>\n<p style=\"text-align: justify;\">If a worksheet with the same name already exists but still you are assigning that name to some other worksheet. In that case, VBA will throw the run time error 1004 along with the message: <strong>\u201cThe Name is Already Taken. Try a different one.\u201d<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5788 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-1-1.gif\" alt=\"VBA Run Time Error 1004 in Excel 1\" width=\"470\" height=\"286\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solution:<\/strong>\u00a0You can fix this error code by renaming your Excel sheet.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#2 \u2013 VBA Run Time Error 1004: Method \u201cRange\u201d of object\u2019 _ Global\u2019 failed<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">This VBA error code mainly occurs when someone tries to access the object range with wrong spelling or which doesn\u2019t exist in the worksheet.<\/p>\n<p style=\"text-align: justify;\">Suppose, you have named the cells range as <strong>\u201cHeadings,\u201d<\/strong> but if you incorrectly mention the named range then obviously you will get the <strong>Run Time Error 1004: Method \u201cRange\u201d of object\u2019 _ Global\u2019 failed error.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5789 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-2-2.gif\" alt=\"VBA Run Time Error 1004 in Excel 2\" width=\"458\" height=\"278\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solution:<\/strong> So before running the code properly check the name of the range.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong># 3 \u2013 VBA Run Time Error 1004: Select Method of Range class failed<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">This error code occurs when someone tries to choose the cells from a non-active sheet.<\/p>\n<p style=\"text-align: justify;\">\u00a0Let\u2019s understand with this an example:<\/p>\n<p style=\"text-align: justify;\">Suppose you have selected cells from A1 to A5 from the Sheet1 worksheet. Whereas, your present active worksheet is Sheet2.<\/p>\n<p style=\"text-align: justify;\">At that time it\u2019s obvious to encounter<strong> Run Time Error 1004: Select Method of Range class failed.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5790 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-3.gif\" alt=\"VBA Run Time Error 1004 in Excel 3\" width=\"460\" height=\"260\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solution: <\/strong>To fix this, you need to <strong>activate the worksheet<\/strong> before selecting cells of it.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#4 \u2013 VBA Runtime Error 1004 method open of object workbooks failed<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">This specific <strong>run time Error 1004<\/strong> arises when someone tries to open an Excel workbook having the same workbook name that is already open.<\/p>\n<p style=\"text-align: justify;\">In that case, it\u2019s quite common to encounter <strong>VBA Runtime Error 1004 method open of object workbooks failed.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5791 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-4.png\" alt=\"VBA Run Time Error 1004 in Excel 4\" width=\"519\" height=\"350\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-4.png 519w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-4-300x202.png 300w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solution: <\/strong>Well to fix this, first of all close the already opened documents having a similar name.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#5 \u2013 VBA Runtime Error 1004 Method Sorry We Couldn\u2019t Find:<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">The main reason behind the occurrence of this <strong>VBA error in Excel <\/strong>is due to renaming, shifting, or deletion of the mentioned path.<\/p>\n<p style=\"text-align: justify;\">The reason behind this can be the wrong assigned path or file name with extension.<\/p>\n<p style=\"text-align: justify;\">When your assigned code fails to fetch a file within your mentioned folder path. Then you will definitely get the <strong>runtime Error 1004 method. Sorry, and We couldn\u2019t find it.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5792 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-5.png\" alt=\"VBA Run Time Error 1004 in Excel 5\" width=\"381\" height=\"214\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-5.png 381w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example-5-300x169.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\n<p><strong>Solution: <\/strong>make a proper check across the given path or file name.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#6 \u2013 VBA Runtime Error 1004 Activate method range class failed<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Behind this error, the reason can be activating the cells range without activating the Excel worksheet.<\/p>\n<p style=\"text-align: justify;\">This specific error is quite very similar to the one which we have already discussed above i.e <strong>Run Time Error 1004: Select Method of Range class failed.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5793 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example6.png\" alt=\"VBA Run Time Error 1004 in Excel 6\" width=\"381\" height=\"214\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example6.png 381w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/VBA-1004-Error-Example6-300x169.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Solution: <\/strong>To fix this, you need to activate your excel sheet first and then activate the sheet cells. However, it is not possible to activate the cell of a sheet without activating the worksheet.<\/p>\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Why This Visual Basic Runtime Error 1004 Occurs?<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\">Follow the reasons behind getting the<strong> run time error 1004<\/strong>:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Due to corruption in the desktop icon for MS Excel.<\/li>\n<li>Conflict with other programs while opening VBA Excel file.<\/li>\n<li>When filtered data is copied and then pasted into MS Office Excel workbook.<\/li>\n<li>Due to application or object-defined error.<\/li>\n<li>A range value is set programmatically with a collection of large strings.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Well, these are common reasons behind getting the <strong>VBA<\/strong> <strong>runtime error 1004<\/strong>, now know how to fix it. Here we have described both the manual as well as automatic solution to fix the <strong>run time error 1004<\/strong> in Excel 2016 and 2013. In case you are not able to fix the error manually then make use of the automatic <strong>MS Excel Repair Tool<\/strong> to fix the error automatically.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>How To Fix Runtime Error 1004?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3149 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion.png\" alt=\"Fix Runtime Error 1004\" width=\"377\" height=\"266\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion.png 1584w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion-300x211.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion-1024x721.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion-768x541.png 768w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/reparacion-1536x1081.png 1536w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/p>\n<p style=\"text-align: justify;\">Follow the steps given below to fix <strong>Excel run time error 1004<\/strong> :<\/p>\n<p style=\"text-align: justify;\"><strong><a href=\"#a1\">1: Uninstall Microsoft Work<\/a><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><a href=\"#a2\">2: Create New Excel Template<\/a><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><a href=\"#a3\">3: Delete The &#8220;GWXL97.XLA\u201d File<\/a><\/strong><br \/>\n<a name=\"a1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Method 1: Uninstall Microsoft Work<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\">1. Go to the <strong>Task Manager<\/strong> and stop the entire running programs.<\/p>\n<p style=\"text-align: justify;\">2. Then go to<strong> Start<\/strong> menu &gt; and select <strong>Control Panel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-3141 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/click-on-control-panel.png\" alt=\"run time error 1004 (1)\" width=\"476\" height=\"371\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/click-on-control-panel.png 635w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/click-on-control-panel-300x234.png 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p style=\"text-align: justify;\">3. Next, in the <strong>Control Panel<\/strong> select <strong>Add or Remove Program.<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3142 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/unnamed.gif\" alt=\"run time error 1004 (2)\" width=\"512\" height=\"332\" \/><\/p>\n<p style=\"text-align: justify;\">4. Here, you will get the <strong>list of programs<\/strong> that are currently installed on your PC, and then from the list select <strong>Microsoft Work<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3140 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/RuntimeError1004-1.jpg\" alt=\"run time error 1004\" width=\"333\" height=\"312\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/RuntimeError1004-1.jpg 333w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/RuntimeError1004-1-300x281.jpg 300w\" sizes=\"auto, (max-width: 333px) 100vw, 333px\" \/><\/p>\n<p style=\"text-align: justify;\">5. And click on uninstall to remove it from the PC.<\/p>\n<p style=\"text-align: justify;\">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 <strong>antivirus program<\/strong> to remove malware and also get rid of the <strong>runtime error 1004<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><a name=\"a2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Method 2: Create New Excel Template<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Another very simple method to <strong>fix Excel runtime error 1004<\/strong> is by putting a new Excel worksheet file within a template. Instead of copying or duplicating the existing worksheet.<\/p>\n<p style=\"text-align: justify;\">Here is the complete step on how to perform this task.<\/p>\n<p style=\"text-align: justify;\">1.Start your <strong>Excel <\/strong>application.<\/p>\n<p style=\"text-align: justify;\">2. Make a fresh new Excel workbook, after then delete the entire sheets present on it leaving only a single one.<\/p>\n<p style=\"text-align: justify;\">3. Now format the workbook as per your need or like the way you want to design in your default template.<\/p>\n<p style=\"text-align: justify;\">4. Excel 2003 user: Tap to the <strong>File&gt;Save As <\/strong>option<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3146 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/shot-excel-save-as-ribbon-700-598.png\" alt=\"SAVE EXCEL FILE\" width=\"700\" height=\"598\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/shot-excel-save-as-ribbon-700-598.png 700w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/shot-excel-save-as-ribbon-700-598-300x256.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<p style=\"text-align: justify;\">OR Excel 2007 or latest versions: Tap to the <strong>Microsoft Office\u00a0<\/strong>button after then hit the\u00a0<strong>Save As <\/strong>option.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3147 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/unnamed.png\" alt=\"SAVE EXCEL FILE 1\" width=\"442\" height=\"493\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/unnamed.png 442w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/unnamed-269x300.png 269w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/p>\n<p style=\"text-align: justify;\">5. Now in the field of <strong>File name, <\/strong>assign name for your template.<\/p>\n<p style=\"text-align: justify;\">6. On the side of <strong>Save as type<\/strong> there is a small arrow key, make a tap on it. From the opened drop menu<\/p>\n<ul style=\"text-align: justify;\">\n<li>Excel 2003 users have to choose the <strong>Excel\u00a0Template (.xlt)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3143 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-1.png\" alt=\"Create New Excel Template 1\" width=\"727\" height=\"375\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-1.png 727w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-1-300x155.png 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>And Excel 2007 or later version have to choose the <strong>Excel\u00a0Template (.xltx)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3144 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-2.png\" alt=\"Create New Excel Template 2\" width=\"682\" height=\"394\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-2.png 682w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Create-New-Excel-Template-2-300x173.png 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/p>\n<p style=\"text-align: justify;\">7. Tap to the <strong>Save.<\/strong><\/p>\n<p style=\"text-align: justify;\">8. After the successful creation of the template, now you can programmatically insert it by making use of the following code:<br \/>\n<strong>Add Type:=path\\filename<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><u>Remarks:<\/u><\/strong><u>\u00a0<\/u><\/p>\n<p style=\"text-align: justify;\">From the above code, you have to replace the <strong>path\\filename<\/strong>\u00a0with the complete path including the file name. For assigning the exact location of the sheet template you have just created.<\/p>\n<p style=\"text-align: justify;\"><a name=\"a3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Method 3: Delete The &#8220;GWXL97.XLA\u201d File<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\">Follow another manual method to <strong>fix Excel Runtime Error 1004:<\/strong><\/p>\n<p style=\"text-align: justify;\">1. Right-click on the <strong>start menu.<\/strong><\/p>\n<p style=\"text-align: justify;\">2. Then select the <strong>Explore option.<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3139 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004.jpg\" alt=\"Excel Runtime Error 1004\" width=\"276\" height=\"99\" \/><\/p>\n<p style=\"text-align: justify;\">3. Then open the following directory \u2013 <strong>C:\\Program Files\\MSOffice\\Office\\XLSTART<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3137 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-1.jpg\" alt=\"Excel Runtime Error 1004 (1)\" width=\"403\" height=\"189\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-1.jpg 403w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-1-300x141.jpg 300w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/p>\n<p style=\"text-align: justify;\">4. Here you need to delete <strong>\u201cGWXL97.XLA\u201d file<\/strong><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3138 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-2.jpg\" alt=\"Excel Runtime Error 1004 (2)\" width=\"379\" height=\"395\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-2.jpg 379w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Excel-Runtime-Error-1004-2-288x300.jpg 288w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><\/p>\n<p style=\"text-align: justify;\">5. And open the Excel after closing the explorer<\/p>\n<p style=\"text-align: justify;\">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 <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>MS Excel Repair Tool<\/strong><\/a>, to fix the error easily.<\/p>\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Automatic Solution: MS Excel Repair Tool<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\"><strong>MS Excel Repair Tool<\/strong> <\/a>is a professional recommended solution to easily <a href=\"https:\/\/www.repairmsexcel.com\/blog\/best-solution-to-repair-excel-xls-xlsx-xlt-xls-xlsm-xlsx-on-windows-or-mac\/?utm_source=repair-excel-xls-xlsx&amp;utm_medium=ref&amp;utm_campaign=bl\"><strong>repair both .xls and .xlsx file<\/strong><\/a>. It supports several files in one repair cycle. It is a unique tool that can repair multiple corrupted Excel files 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 systems.<\/p>\n<p style=\"text-align: justify;\"><center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Steps to Utilize MS Excel Repair Tool:<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\">\n<h2 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">Conclusion:<\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\">Hope this article helps you to repair the <strong>runtime error 1004<\/strong> in Excel and recovers Excel file data. In this article, we have provided a manual as well as automatic solution to get rid of <strong>Excel run-time error 1004<\/strong>. You can make use of any solution according to your desire.<\/p>\n<p style=\"text-align: justify;\"><em><strong>Good Luck!!!<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u00a0Summary: In this post, I have included the complete information about Excel runtime error 1004. Besides that I have presented &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How To Repair Runtime Error 1004 in Excel?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#more-84\" aria-label=\"Read more about How To Repair Runtime Error 1004 in Excel?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":5423,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[41,859,838,858,39,40],"class_list":["post-84","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-common-runtime-error-1004","tag-error-1004","tag-excel-runtime-error-1004","tag-run-time-error-1004","tag-solutions-for-runtime-error-1004","tag-why-this-runtime-error-1004-occur","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Fix Runtime Error 1004 in Excel?<\/title>\n<meta name=\"description\" content=\"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The &quot;GWXL97.XLA\u201d File AND MORE\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Fix Runtime Error 1004 in Excel?\" \/>\n<meta property=\"og:description\" content=\"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The &quot;GWXL97.XLA\u201d File AND MORE\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-09T12:55:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-19T11:53:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How To Repair Runtime Error 1004 in Excel?\",\"datePublished\":\"2015-07-09T12:55:48+00:00\",\"dateModified\":\"2021-08-19T11:53:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004\"},\"wordCount\":1557,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Runtime-Error-1004-in-Excel.png\",\"keywords\":[\"common runtime error 1004\",\"error 1004\",\"excel runtime error 1004\",\"run time error 1004\",\"Solutions for Runtime error 1004\",\"Why this runtime error 1004 occur\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004\",\"name\":\"How To Fix Runtime Error 1004 in Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Runtime-Error-1004-in-Excel.png\",\"datePublished\":\"2015-07-09T12:55:48+00:00\",\"dateModified\":\"2021-08-19T11:53:11+00:00\",\"description\":\"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The \\\"GWXL97.XLA\u201d File AND MORE\u2026\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Runtime-Error-1004-in-Excel.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/Runtime-Error-1004-in-Excel.png\",\"width\":550,\"height\":300,\"caption\":\"Runtime Error 1004 in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/how-to-fix-runtime-error-1004#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Repair Runtime Error 1004 in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Fix Runtime Error 1004 in Excel?","description":"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The \"GWXL97.XLA\u201d File AND MORE\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004","og_locale":"en_US","og_type":"article","og_title":"How To Fix Runtime Error 1004 in Excel?","og_description":"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The \"GWXL97.XLA\u201d File AND MORE\u2026","og_url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004","og_site_name":"Excel File Repair Blog","article_published_time":"2015-07-09T12:55:48+00:00","article_modified_time":"2021-08-19T11:53:11+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How To Repair Runtime Error 1004 in Excel?","datePublished":"2015-07-09T12:55:48+00:00","dateModified":"2021-08-19T11:53:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004"},"wordCount":1557,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png","keywords":["common runtime error 1004","error 1004","excel runtime error 1004","run time error 1004","Solutions for Runtime error 1004","Why this runtime error 1004 occur"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004","url":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004","name":"How To Fix Runtime Error 1004 in Excel?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png","datePublished":"2015-07-09T12:55:48+00:00","dateModified":"2021-08-19T11:53:11+00:00","description":"Try best fixes to resolve Excel runtime error 1004. METHOD 1: Uninstall Microsoft Work, METHOD 2: Create New Excel Template, METHOD 3: Delete The \"GWXL97.XLA\u201d File AND MORE\u2026","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/Runtime-Error-1004-in-Excel.png","width":550,"height":300,"caption":"Runtime Error 1004 in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/how-to-fix-runtime-error-1004#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How To Repair Runtime Error 1004 in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/84","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=84"}],"version-history":[{"count":0,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/5423"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}