If you ever encounter any issues with Excel transfer or import, follow the troubleshooting tips given below to fix the issues. The following tips are applicable for all eGrabber products.

Basic Troubleshooting Tip 1

This is the first and basic troubleshooting technique you should try to fix the Excel transfer/import issue.  

Try the following:

1. Close the eGrabber product and all Excel files.
2. Go to Task Manager and click on the Details tab to ensure no instances of Excel.exe is running.
3. Go to install directory and look for the following files:

For Excel 2013 and above, select MSExcelPlugin2010.bat > Right-click>Edit

• Add “Pause” at the end of the bat file.
• Click Save and exit.

For Excel 2013 below 2013, select MSExcelPlugin.bat> Right-click>Edit

• Add “Pause” at the end of the bat file.
• Click Save and exit.

4. Now, run the edited bat file as admin .

The following screen is displayed.

Ensure that you are getting this message – “Types registered successfully”

Note: If you are not receiving the above message “Types registered successfully”, reach out to the engineers.

5. Now, try to transfer or import the Excel file.

Registry Entry Mismatch – Troubleshooting Tip 2

The following tip will help you to check if there is any registry entry mismatch found with respect to Excel and remove the same. Usually this issue arises when the user installs the latest version of Microsoft Excel and uninstalls the same. During uninstallation, the registry entry for the latest version still remains in the registry. Now, when the user tries to use a lower version of Excel, it throws up an error during transfer.  

Follow the steps given below to find and fix the issue:

Note: Ensure that you close all eGrabber products and Excel while doing the following steps

Go to Run > regedit > Go to “Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}”

The above image illustrates that the user has installed Excel 2010 installed in her computer. The user has also installed Excel 2016 and uninstalled the same. But the registry entry was not removed. 

If the user wants to transfer to Excel 2010, she has to manually remove the registry entry for Excel 2016. 

Registry Entries for Various Excel Versions 

1.9 – for Excel 2016

1.8 – for Excel 2013

1.7 – for Excel 2010

1.6 – for Excel 2007

Before manually deleting the registry entry, take a backup by exporting it.

Now, delete the registry entry.

Troubleshooting Tip 3

If nothing works, try repairing Microsoft Office. 

If the issue persists even after repairing Microsoft Office, try to trace down the problem and fix it by accessing the user logs.

If you still can’t figure out the problem or find a solution, reach out to the engineers.