Excel not publishing OLE

Since you've already performed the standard first-aid, you need to engage with the problem at a higher level.

What you can try…

Reset Office Upload Center settings

• Close all Office applications.
• Open File Explorer and navigate to %localappdata%\Microsoft\Office\16.0\OfficeFileCache.
• Delete all the files in this folder. Be careful not to delete the folder itself.
• Restart your computer and then try the OLE copy operation again.

Examine Office registry entries related to OLE

• Press Win + R, type regedit, and press Enter to open the Registry Editor.
• Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common\OLE.
• Check if there are any abnormal or missing registry values. You can compare these values with a working system (if possible). For example, some values might control how Excel exposes its OLE objects to other applications. If you find any suspicious values, you can try resetting them to their default values or deleting them (after backup).
• Also, check HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\OLE for any system - wide OLE - related settings that might be affecting Excel.

Carefull: Modifying the registry can be risky. Make sure to back up the registry before making any changes. Incorrect registry modifications can cause serious system problems.

Test with a different user account

This could help determine if the problem is related to your specific user profile settings or permissions.

Check for software conflicts with other applications

Some third - party applications might interfere with Excel's OLE functionality. Like, Antivirus Software, Third - Party Excel Add – ins, Screen Capture and Recording Software, File Synchronization and Backup Software, Other Office Suites or Productivity Software, etc.

These are all just suggestions as to possible causes, based on the information you provided. However, more detailed information could lead to more specific suggestions. Information about the operating system, storage medium, network, etc., could also be helpful.

I hope this information has been helpful to you.