Found the answer to my problem on another site. In case anyone else has this problem....
This did fix my problem
Bring up the Excel options, go to advanced and then scroll down to the
"General" section. Make sure that "Ignore other applications that use
Dynamic Data Exchange (DDE)" is not checked.This did fix my problem