I am unable to use the ChemDraw for Excel v20 add-in on my Mac.
Please check the features available for each suite in the version 20 Software Requirements guide:
The ChemDraw for Excel feature is available only in ChemDraw Professional and ChemOffice+ Cloud
(Previously named ChemOffice Professional) for Windows.
Unfortunately, Mac OS is not supported for the ChemDraw for Excel plugin.