This happened to me yesterday. We are on office 365, so I opened setting, Apps, and selected modify for Office 365:
And now I can copy to Excel.