When exporting to Excel, "Unable to cast to COM object" error appears

When exporting a created list to Excel, the following error appears:

This can be the result of a faulty interaction between Windows 10 and Office 365. 

Certain users are encountering an error when attempting to add or modify a datalink, with the error message indicating, "The data link cannot be created because Excel cannot be found."

In order to fix this error, navigate to the system's apps & features and right-click Office 365. Then select "Modify".

A pop-up should appear:

Make sure that "Quick Repair" is selected and then click "Repair". Follow the prompts to finish the repair process.

Once repaired, reattempt to export the list to Excel.

Regarding the datalink - Please refer the below link from Autodesk, If issue is not resolved by repairing the MS office.

https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/Error-using-Datalink-in-AutoCAD-cannot-add-link-because-excel-cannot-be-found.html

• Related Articles

• How to configure the HyDraw Parts List Style

  1. Select the Parts List. 2. Go to Annotate Ribbon Menu, in the Tables section, select the Table Style… Option. 3. Click the Modify… button. 4. Switch to Text tab and click the Text Style Ellipses button 5. Select the required Font Name and Height. ...

• With Dot/Dash separator in Component Code, Identical Items are not grouped in Parts list.

  When Dot/Dash separator is used in Component Code in HyDraw Library Manager, the Parts list will not group the Identical items. This is a technical design limitation in HyDraw CAD. Workaround: Use Semicolon(:) instead of Dash/Dot in Component code ...

• HyDraw CAD 2022 License won't apply and throws an Object Reference error

  When applying the HyDraw CAD 2022 CLS ID for Single-user License, the program gives the following error: Follow the instructions below to set an exclusion for the HyDraw CAD executable: Go to Start > Settings > Update & Security > Windows Security > ...

• Can you update Parts List after it has already been inserted without deleting it?

  Refer to link on how to Update Parts List, Auto Update Parts List.  

• How to use the HyDraw - Update from Excel Interface?

  Refer the video to learn how to use the interface inside HyDraw CAD. This video shows how to update the list price for components in the drawing from the Excel file using the Update from Excel command. Step 1 Export data from your ERP system into an ...