COM for Excel AD
Excel AD requires the Excel COM library.
Excel AD requires a Fully functioning copy of Excel installed. That means Excel must be capable of running VBA macro’s and have the COM library installed.
The Excel COM library option needs to be selected when Excel is installed.
Some of the subscription versions of Excel may not work with Excel AD.
Microsoft 365 Apps for business seems to work
How to Test the Excel Installation for COM capability.
In MS PowerShell run the following command.
$excel = new-object -comobject excel.application
The command should run without error.