Excel 2016 and later with Windows 10 security updates - Metasys - LIT-12014183 - Software Application - Metasys Advanced Reporting System - 3.0

Metasys Report Engine User Guide
Product
Building Automation Systems > Graphics and Interfaces > Metasys Advanced Reporting System
Document type
User Guide
Document number
LIT-12014183
Version
3.0
Revision date
2023-03-06
Product status
Active

Symptom:

After you install Windows 10 security updates, the Excel reports are no longer created and the following error is reported in the MRE’s report log file:
Unexpected error: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070520.

Cause:

Security updates from Microsoft prevent use of DCOM objects from any user but the interactive user.

Solution:

To change the DCOM settings for Excel application complete the following steps:

  1. Click the Windows Start button and enter dcomcnfg.

    Note: If you running 32-bit version of Office on a 64-bit Windows OS, follow these steps
    1. Click the Windows Start button and type cmd, then click Run as administrator
    2. Type the following command
      MMC compex.msc /32
  2. Click the icon to run the DCOM configuration console.
  3. Expand the DCOM Config node and scroll to the Microsoft Excel application node.
  4. Right-click and select Properties.
  5. Navigate to the Identity tab.
  6. Select The interactive user option.
In order to ensure the correct user is logged in, enable automatic log on. Please follow these steps (for a complete guide, please refer to https://support.microsoft.com/en-us/help/324737/how-to-turn-on-automatic-logon-in-windows)
  1. Click the Windows Start button and type “regedit”
  2. Click the icon to launch the Registry editor
  3. Locate the key
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon
  4. Locate the entry DefaultUserName. If the entry does not exist, right-click on the Winlogon key and select New -> String value. Rename the new entry as DefaultUserName
  5. Double-click on the entry DefaultUserName. Enter a Windows account name who has the rights to run Excel (it to strongly recommended to use the same user the MRE service runs as)
  6. Locate the entry DefautPassword. If the entry does not exist, right-click on the Winlogon key and select New -> String value. Rename the new entry as DefaultPassword
  7. Double-click on the entry DefaultPassword. Enter the password of the Windows account
  8. Locate the entry AutoAdminLogon. If the entry does not exist, right-click on the Winlogon key and select New -> String value. Rename the new entry as AutoAdminLogon
  9. Double-click on the entry AutoAdminLogon. Change the value to 1
  10. If you have joined the computer to a domain, you should add the DefaultDomain value, and the data for the value should be set as the fully qualified domain name (FQDN) of the domain.
  11. Exit Registry Editor.
  12. Restart the PC