Paste options stopped working correctly copying data using Excel

Recently when I copy data from Microsoft Excel into an Outlook email or Word doc I can no longer paste as either "Keep Source Formatting" "Use Destination Styles" "Link & Keep Source Formatting" etc. The only options that work are "Picture" and "Keep Text Only". I have done a quick repair on Office 2016 and the full online repair option which had a problem so I had to uninstall and re-install Office 2016. Before that I tried starting Excel in safe mode as well. Nothing has worked so far. Any ideas?