THe issue was resolved when we went to Trust Center -> Trust Center Settings ->ActiveX Settings and clicked the "Prompt me before enabling all controls with minimal restrictions" and restarted Excel.