ChemDraw for Excel: How do I use or enable the Search option in ChemDraw for Excel

How do I use or enable the Search option in ChemDraw for Excel?

The ChemDraw for Excel option is only available if you have a ChemDraw Professional or ChemOffice license.  You also need to use the Create New ChemOffice Worksheet or Convert Worksheet option to enable the ChemOffice functions.

The Search button only works when you open an existing database.  It will not work when you create the file directly in Excel.

Solution:

To enable this feature, you must import a table or a database (for example: ChemOffice21>Import/Export>Import Table or Import ChemFinder list).

You can export your table first as an SD File and then re-import it to be able to use the search option.