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 ...