EXCEL EXPORT / IMPORT || Error in Loading DLL in excel export / Automation error - Library not registered

EXCEL EXPORT / IMPORT || Error in Loading DLL in excel export / Automation error - Library not registered

Error in Loading DLL in excel export / Automation error - Library not registered in Excel export








Solution :


NOTE : This is not Software Related issue.

Usually error in loading dll Excel arise when due to the installation of any software the new DLL files overwrites the previously existing DLL file.
Apart from this, many DLL errors also occur due to the removal or corruption of the DLL files.
This at the end results in following DLL errors: “The DLL file is missing” or “The DLL file is not found” or “Error in Loading DLL” etc.


1. Uninstall Complete MS Office in the system with the folders available in Program file / Program files(x86).
2. Remove registry keys created by the MSI installation of Office by deleting the registry keys - 

- Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office

            

- Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office

            

- Computer\HKEY_CLASSES_ROOT\TypeLib\{00020813-0000-0000-C000-000000000046}\------

            

3. Restart the system.
4. Now Install MS Office.

Now, start application and try again.

If same issue occur please contact your system engineer to get it resolved.
    • Related Articles

    • 24G - Excel import error regarding DDO number

      24G - Excel import error regarding DDO number  Solution  This error come when you import the 24 G detail from excel and entering duplicate DDO number in transaction sheet for same month, as per NSDL guide line same DDO number for same form and month ...
    • Excel Import Error "challan is not getting mapped"

      Excel Import Error "challan is not getting mapped" Possible Resolution To solve this excel import issue, here are some suggestions are given below. 1.  All mandatory details should be filled in the "Challan Details" Sheet. * Challan number * Deposit ...
    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...
    • TDS Correction Excel Import "Error converting data type varchar to numeric"

      TDS Correction Excel Import Error:- 2147217913 Error converting data type varchar to numeric Possible Resolution To solve this excel import issue, here are some suggestions are given below.  1. In the Excel template, it is to be checked that the ...
    • How to Export GSTR-2 data in MS Excel?

      To export GSTR-2 returns Data in the MS Excel follow the steps below : Go to Gateway of Tally > Display > Statutory Reports > GST > GSTR-2 Make sure that there are no items under the section Not included in returns due to incomplete information     ...