Hi!
I am creating a basic desktop application in order to refresh external data connections and pivot tables within Excel. I am using the interop library. I am getting the following error:
Retrieving the COM class factory for component with CLSID {ID} failed due to the following error:
80080005 Server execution failed (0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
(I can include the ID if that is necessary)
I have looked online for this error and understand its an issue with opening the excel workbook? I have tried multiple solutions including opening dcomcnfig to make sure the current logged in user is what is opening it. Is there possibly a compatibility issue? I'm on windows 11. Thanks so much!