HomeWindowsHow to Fix Microsoft Excel Run-time Error 1004

How to Fix Microsoft Excel Run-time Error 1004



Many people are using Microsoft Excel for organizing their data files and storing information. MS Excel as part of the Microsoft Office suite is easy to use and offers useful functions that can help manage data faster.

Seeing an error when using the spreadsheet can frustrate you, but it happens to all programs and devices. Find a solution to fix the error and go back to your work.

One of the common errors found in MS Excel is the run-time error 1004. It is associated with Microsoft Visual Basic while affecting MS Excel. You can find different variations to the error, depending on its cause.

The run-time error can disrupt your workflow and prevent you from continuing your work.

Causes of Microsoft Excel Run-time Error 1004

Here are some issues that may contribute to the run-time error 1004 in Microsoft Excel.

  • There may be more legend entries on the chart.
  • The Microsoft Excel desktop icon may be corrupted.
  • The range values in the chart are not properly set.
  • There may be programs running the background that conflict with the file.

Fixing Run-time Error 1004 in Microsoft Excel


Solution #1 – Create a New Workbook

  • Open MS Excel.
  • Press CTRL+N to open a new workbook, or you can select Blank Workbook.
  • Delete all the sheets in the workbook, leaving Sheet 1 behind.
  • Now, try to format the workbook the way you want it. You can add charts of templates.
  • Once done, save your work by clicking File and selecting Save As.
  • Enter your file name.
  • Under Save as type, select Excel Template (.xlt) or Excel Template (.xltx), depending on the version you are using.
  • Click Save.
  • Now, you can insert this template using the code: Sheets.Add Type:=path\filename. Just change the filename to the actual filename you saved the document.

Solution #2 – Uninstall Microsoft Works

  • Open the Task Manager. You can search it, or you can press the CTRL + ALT + DEL buttons together.
  • Stop all the programs that are running.
  • Go to Programs and Features by launching the Run dialog box and typing appwiz.cpl. In some cases, you will have to go to Start and open the Control Panel. From there, click Add or remove program.
  • Look for Microsoft Works and click Uninstall.

Solution #3 – Remove the GWXL97.XLA File

  • Open the File Explorer by pressing Windows key + E.
  • Navigate to this file: C:Usersuser nameAppDataLocalMicrosoftExcel.
  • Next, look for the XLStart folder and click to open.
  • Look for the GWXL97.XLA file and delete it.

Was the article helpful? Let us know below which methods above helped you fix the run-time error on your MS Excel.


More From

How to Change or Adjust DPI Display Scaling Level on Windows 11 PC

The display on your laptop or desktop computer screen or monitor may not always appear as comfortable as you want it to be. Sometimes,...

How to Add, Install, Use Google Meet on Windows PC or Mac

Video conferencing is gaining popularity these days. With people all over the world working within the comforts of their homes, it is crucial to...

Fix Roku TV Screen Mirroring Not Working on Windows 10 PC

Watching your content is a lot better on a bigger screen than doing it from an Android or iPhone device and even from a...

How to Fix Error Code DRMCDM78 when Streaming in Hulu

Hulu subscribers enjoy the benefit of watching their favorite live and on-demand shows and movies. On top of it, they have the option to...


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected