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.
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 > ...
Upon opening a title block, an unhandled exception error appears
Issue: Upon using the 'Insert Title Block' command, the following unhandled exception error displays: Solution: Open the template (.dwt) file from the templates folder. Ensure that there are no hidden entities within the file. Only the Title Block ...
When opening HLM, an error message appears mentioning a missing dll in MS Office 2016
Problem When opening HLM, the following error message appears and forces the application to close: Additionally, when opening HyDraw CAD, the following error appears: Solution: This error appears on users with Office 2016 or Office 365 and is due to ...