Unable to Write to Excel

[Mike_Engel1]

I Will start with the basis that this may not be a Dynamo Issue.

After having swapped out a computer and installing Fresh Revit 2018 & Dynamo. The ability to write/read to Excel no longer works. This has been attempted in Dynamo Revit / Sandbox / Studio - None work.

Excel Functions, and Revit Function as normal other wise.

Curios if anyone else may have seen this condition?

[Kulkul]

Hi @Mike_Engel1

What does the error says?

[Mike_Engel1]

It Reads the following.

“Warning: Excel.WriteToFile Operation Failed.”

[awilliams]

@Mike_Engel1 Do you have Microsoft Office 365 Business by chance? I recently had this problem after Office 365 updated, and @Kulkul recommended uninstalling and reinstalling Microsoft Office 365 Business - after this my Excel nodes in Dynamo worked again. This thread here also offers some other solutions:

Excel.ReadFromFile operation failed

@htlcnn, sometimes something goes wrong with Excel. Have a look at the known issues here: Excel nodes can be rendered non-functional by bad registry data. To correct this: Go to Start–> Run --> regedit. Browse to HKEY_CLASSES_ROOT–>TypeLib–>{00020813-0000-0000-C000-000000000046}. Delete the 1.8 key. We recommend using Excel 2013 or higher. Excel 2010 works in most cases, but 2007 does not. You can also dive into this thread, maybe, it’ll help you: Excel Nodes Fail Dynamo 1.1.0

[Mike_Engel1]

Thank you all - Fixing the Registry and an Reinstall of Microsoft Office Fixes it.

This only brings up the want to have better / more effective search ability on this forum.

[Kulkul]

@Mike_Engel1 Could you mark the post as solved. You’re Welcome!