eGrabber Support

How to troubleshoot Excel PRD issues across all eGrabber products

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.

    • Related Articles

    • How to export the grabbed list to Excel?

      LeadGrabber Pro enables you to quickly copy all the records or selected records from the grid to Excel file. To copy records to Excel, Select the records in the grid. Click the drop-down arrow next to "Copy" button on the LeadGrabber Pro grid toolbar ...
    • How to perform Boolean Searches in LinkedIn for highly narrowed prospects?

      For advanced targeting your prospects, use Boolean Searches in LinkedIn.  Although our product automates few of the processes using this, you can use this for narrowing down your prospects much better!  Please let us know your feedback or queries ...
    • View number of checked records in the grid

      f you have a large set of data, sometimes you might have to delete or deselect few of the records for performing selective operations.  In such cases, you might need to view the number of checked records against the total number of records in the ...
    • How to target prospects in the suburbs of a region?

      The process is explained with an example of targeting the suburbs of Chicago. Example: How to pull a list in the suburbs of Chicago vs downtown Chicago? There are 3  ways that people normally do this on LinkedIn 1. Using a search by Region - Slightly ...