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.



Please enter your comment!
Please enter your name here

More From

Fix Adobe Acrobat Reader Cannot Open PDF Files in Windows 10

Sending a PDF file enables us to transfer a document without the risk of other users altering the original data structure. It retains the...

How to Fix Deleted Files Keep Coming Back on Windows 10

Deleting unused files and folders from your Windows 10 computer can help free up some precious storage space. If you don't want to see...

How to Fix Together Mode & Large Gallery View Not Available in Microsoft Teams

Video conferencing created a different kind of experience in organizations. With it becoming a necessity at work, many people are adjusting to the new...

Microsoft Teams Keyboard Shortcuts and How to Use Them

More and more organizations and companies use Microsoft Teams as their online collaboration tool of choice. That's mostly because of the strong support from...

Recent Articles

Stay Connected