Recently, when an Excel file is opened, an error occurs that the object link and embedding cannot be used (cannot use Object Linking and Embedding .), attempts to fix, reinstall the office, and Excel failed to solve the problem. Finally, I checked the information on the Internet and said it was caused by viruses (infected by worms), so basically all patches were installed, after several hours of security updates -_-! The problem can be solved. The result shows no... Disgusting!
Finally, I found a solution in a foreign forum, but it is not the same as his (his problem also occurs in the DCOM configuration ). In the DCOM configuration, I configured
Microsoft Excel application --> properties --> identity
Select the interactive user or the launching user. Option (items 1 and 2)
If this user is selected (item 1), the error "cannot use object link and embedding" (cannot use Object Linking and Embedding.) will occur.