Fix Error 1004

Error 1004 in Windows 7, Vista and XP may occur on PCs where iTunes and Microsoft Office Excel programs get corrupted. Microsoft Office Excel may show you Windows error 1004 while copying worksheet automatically. This error may occur due to programming errors or otherwise due to problems in the MS Excel registry entries. On the other hand, iTunes may show you error 1004 if its registry configurations are incorrect. Let us see the actual steps to solve Windows error 1004 in Windows 7, Vista and XP besides this automatic fix available here:



Compatible with Windows 7, Vista and Windows XP

Solve Internal Registry Conflicts

Incorrect registry configurations can be the main source of error code 1004. For example, an important registry entry is modified in incorrectly. You need to analyze the state of your registry and then take actions accordingly.Download a Registry Cleaner.software and clean-out your registry.

Save and Close Worksheet Periodically While Copying

In order to fix error 1004 in Windows 7, Vista and XP, save and close the active worksheet periodically while it is being copied. In other words, when the copy process is being performed, save and close that worksheet.

The code to save your worksheet is as below:

oBook.SaveAs "c:\test2.xls"

Here, C:\ is the drive letter and Test2.xls is the file name. You may replace these values with anything other you prefer.

Insert a New Worksheet from Templates

Another way of solving error 1004 is to insert a new worksheet from the templates available on your computer. The steps required to do this task are as under:

  • 1) Open Microsoft Office Excel.
  • 2) Click File | New.
  • 3) Select a template and click Create button.
  • 4) Format the worksheet. Then click File | Save As.
  • 5) Specify a file name and choose a parent directory.
  • 6) From the Save as Type box, select Template (*.xltx) option.
  • 7) Click Save button.

Put your Device in DFU Mode

To solve error 1004 on iTunes, you have to put the corresponding device on the DFU mode. To do so, follow these guidelines:

  • 1) Connect the iPhone to your computer.
  • 2) Turn the iPhone off.
  • 3) Launch iTunes application.
  • 4) Hold both Power and Home buttons together for at least 10 seconds.
  • 5) Release the Power button but keep holding the Home button until your computer recognizes the newly connected USB device.

Change the Settings to System Defaults

Error 1004 may occur if iTunes is not properly configured. Reset the application settings to solve the problem:

  • 1) Open iTunes.
  • 2) Click Settings | General | Reset.
  • 3) Confirm the action by clicking Reset all settings.