If SAS is unable to open Excel files and gives error message: "Connect Class not registered" or "Connection Failed," this is likely due to a 32-bit - 64-bit mismatch between the SAS and Microsoft Office versions installed or a missing Microsoft registry component (see this SAS support article).
Possible fix (successfully used by Service Desk staff)