ACT sales report running in Excel Macro needs repairing

I was running ACT v10 CRM software on a Windows 7 PC. I have a new PC running windows 10 and now run Act! (Web) Version: 22.1.212.0, Update 4. My sales report from Version 10 runs in the new version generating a word document with data spread across 17 columns. However, when I select the data then go to paste it into my Excel Macro to run the sales report, the Data which should be spread across 17 columns appears all in column 1. The report will not run. Can someone fix this for me?