How to fix RTD server issue on windows 11 with Microsoft 365

Question

I created an RTD server using pywin32. Initially it did not work.

But after i did a clean install of windows 11, it ran for 1 day and subsequently, it was returning #N/A to excel. In excel=>file=>option=>add-in, the ProgId is listed under inactive application add-in. The ProgID is not listed in either COM add-in or excel add-in.

I checked to be sure the python implementation is registered in the registry.

I need support to fix this. thank you.

Answer 1

I have been able to fix this issue with internet search and ChatGPT.

Solution I implemented.

1. Added ProgID as key to this HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\YourServer.ProgID\
2. Added these values under the key: Set LoadBehavior value to 3
3. included HKEY_CLASSES_ROOT\CLSID{Your-RTD-GUID}\Implemented Categories{0002E005-0000-0000-C000-000000000046}: this value identifies the server as an excel add-in. add to whatever has been there.
4. Ensure this also: HKEY_CLASSES_ROOT

           CLSID      {Your-Server-GUID} 
   
           InprocServer32            
   
                     (Default) = C:\Path\To\Your\Server.dll 
   
                      ThreadingModel = Apartment 
   
                      LoadBehavior = 0x00000003
   
           ProgID = Your.Server.ProgID
   

   I hope this helps someone.