Error in Loading DLL / Automation error - Library not registered

EXCEL Export || Error in Loading DLL / Automation error - Library not registered

At the time of excel sheet export issue occur --> error in Loading DLL / Automation error - Library not registered


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.

Regarding this issue, kindly initiate the repair process for the installed MS Office on your specific system by following these steps:
  1. Press the "Windows key + R".
  2. Type “Control panel” and press Enter.
  3. Navigate to Programs or Programs and Features (depending on your Windows version).
  4. Locate Microsoft Office in the list of programs.
  5. Right-click and select Change or Repair.
  6. Follow the on-screen instructions to complete the repair.
  7. Restart the System and then check with software.

If not Done, Please follow the Steps below:

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

    • eXBace || Data import and export through excel

      To reduce complications of data entry In eXBace software, a facility has been provided where the user can import data through excel and can export data in excel. The User can also validate every sheet where the data is entered at the same time. The ...
    • Income Tax || How to export Client Master Data in Excel

      Exporting client details in an Excel sheet from the Income Tax Software is a straightforward process. Here's a step-by-step guide: Step 1: In the Income Tax Software, navigate to Reports → MIS → MIS option in the menu bar. Step 2: Click on the ...
    • SQL SERVER || Fusion Active Template Library (ATL)

      Error While Installing SQL SERVER 2008 R2 SP2 Express Edition – Fusion Active Template Library (ATL) Resolution Solution 1: To resolve this problem, use the following methods: Disable Antivirus and Firewall as well until SQL Server Installation. In ...
    • 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 || MACRO Enabled Process

      Unblock a single file In most cases, you can unblock macros by modifying the properties of the file as follows: Open Windows File Explorer and navigate to the folder "C:\Program Files (x86)\K.D.K. Software\Spectrum\Zen TDS\e-TDStcsfvu". Right-click ...