To fix the problem, we should do like this, and this is for Excel 2013 and Excel 2010:
- Click the File tab, and then click Options.
- Click Advanced, and then click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area. (You need to scroll down quite a lot to see the General area)
- Click OK.