Excel Instance crashes if a user logs in to the server (Office 2019).
Hello,
I am facing an issue with our .NET application that generates reports in multiple formats such as Word, Excel, PowerPoint, etc.., in this process it opens the excel instances and does few operations to add data and closes them. The application is installed as a Windows service on a server and is configured to run under the logon user Y and the Excel application is configured to 'launching user' under Identity tab on the DCOM component services.
As the Excel is set to launching user, instances opened by the application would be using user Y.
The Problem:
Whenever an Excel report is being generated, the process gets aborted if any user other than Y is logged in to the server (Remote Desktop Connection) at that time. The Event Viewer on the system captures an Application Error stating that the Excel instance has crashed due to what appears to be permission or memory access issues. Additionally, when I checked the license information for Office 2019 Excel, I noticed an error related to the license, which could potentially be linked to the issue.
Event Viewer error:
Faulting application name: EXCEL.EXE, version: 16.0.10416.20058, time stamp: 0x679af0c3
Faulting module name: ntdll.dll, version: 10.0.14393.4530, time stamp: 0x60e33cac
Exception code: 0xc0000005
Fault offset: 0x00000000000a9922
Faulting process id: 0x1..70
Faulting application start time: 0x01db8.802494da0a3
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: e36d801-4e0-407b-.....
Faulting package full name:
Faulting package-relative application ID:
Office License Information:
Microsoft (R) Windows Script Host Version 5.812
Copyright (C) Microsoft Corporation. All rights reserved.
---Processing--------------------------
PRODUCT ID: ........
LICENSE NAME: Office 19, Office19Standard....
LICENSE DESCRIPTION: Office 19, VOLUME_KMSCLIENT
LICENSE STATUS: ---LICENSED---
ERROR CODE: 0x4004F040 (for information purposes only as the status is licensed)
ERROR DESCRIPTION: The Software Licensing Service reported that the product was activated but the owner should verify the Product Use Rights.
REMAINING GRACE: 179 days (258510 minute(s) before expiring)
Last 5 characters of installed product key: XXXXXX
Activation Type Configuration: ALL
DNS auto-discovery: KMS name not available
KMS machine registry override defined: XXXXXX
Activation Interval: 120 minutes
Renewal Interval: 10080 minutes
---Exiting-----------------------------
Note: The same application works fine in other servers where I have Office 16 with MAK certificate.
Things I have tried:
I have checked permissions, everything looks good (folder permissions, COM security, DCOM Excel application permissions).
I have tried opening an excel with user Y when logged in with different user, with the help of 'runas' command. I could open the application properly.
I have ran sfc/scannow and the results are positive.
I have done Office online repair, still did not work.
I have removed the add-ins on excel.
I was hoping someone might be able to help me to resolve the above issue.
Thank you in advance!